Thread: Split data on basis of cell value

Hi all...
I am an SQL guy and recently got a task to do in excel and i dont have any clue to solve this.

i have some columns and their values say

ID Name Type
1 AS C
2 AD C
3 AF D
4 AL C

I just want to write something which split this sheet on the basis of "TYPE" column. So the final Excel Sheet looks similar to

ID Name Type
1 AS C
2 AD C
4 AL C

ID Name Type
3 AF D

This there any way to achieve this in Excel.
many Thanks in Advance

One possible solution is to sort the data by type and then use DATA > SUBTOTALS