Return multiple items of a category in a column

[pvp1900]

Dear all,

I am trying to do the following:
In my Target sheet I want to display under each of 2 upper categories several subcategories in separate rows.
The 3 upper categories are Category A and Category B
Each upper category contains different sub categories, which may appear multiple times.
For example sub category 0365 appears several times since it contains different Resource Units

My aim is to return under each upper category each sub category in a separate row (see column C as of row 12 blue coloured cells)
I am using a nested formula containing index, small and row function
However my formula does not work.

Can someone help?

Many thanks in advance

[Pauleyb]

This should get you started.

In cell F12 type:
=INDEX(Source!$I$5:$I$46,AGGREGATE(15,6,ROW($1:$41)/(Target!$C$9=Source!$H$5:$H$46),INT((ROW()-9)/3)))
Drag it down to F40. This will just show the Category A items. Since your spreadsheet format actually has these skip three rows (i.e. C12 to C15 to C18), this equation 'repeats' so you'll need to delete the ones you don't want (e.g. F13, F14, F16, F17, etc.)