Filtering and Separating Data
There is an Excel file that teaches how to perform the Filtering and Separating Data operation.
Excel Solution: Filtering and Separating Data
This workbook demonstrates filtering and separating data using VBA macros on a 16-row data layout.
Hope it is useful.