I have excel data, which I want to group by a number of conditions. I know I
could do this automatically in Access, but is there a way to do this in Excel
?

Pivot Tables might do this, but the only problem I face is that I need the
grouped data with all headings populated, unlike how data is presented in
Pivot tables.

Eg. I want the data to be grouped by heading 2 then, heading 2, then heading
6 and the amounts from the gouping summed. Any help would be appreciated.