How to sort Grouped data in Excel

**MarvinP** · 07-01-2011, 10:06 AM

I didn't know we were getting graded on our answers.

I would have made mine easier if I knew.

**Noshiza** · 01-18-2012, 12:42 AM

Hello Everyone,

I have just run in to this problem myself. I have a few groups or "Layers" as I like to call them of information. I have a master header which explains the level 2 information and then another header which explains level 3 information. What I am trying to do is to sort by the Level 2 headers and keep all the information underneath it linked to that header. That way I could pull the grouped row out and put it somewhere else and the information it had below it will stick with it. This isn't working for me in Excel 2003, I have read the replies and tried doing it the Subtotals way but that is no good. I am up for any suggestions!

Thank you,
Blake