Filter with Multiple Header Rooms

[Rob #4]

I have a spreadsheet that has about 100 Items in which there is a Header Row for each item and then sub items that breakdown these Items into smaller items by areas. Each sub item total equals the Header Item total. Is there a way for me to filter this spreadsheet so I can get summaries of each area and not lose the Header Row?

 

[Peter_SSs]

To have any chance of getting a useful suggestion I think you would need to show us a small set of dummy sample data and the expected results and explain again in relation to that sample data.