Group raw data by Table Header
Group data by table headers to automatically band / group them up (a row header and a row footer separates the data in a table based on the grouping). A pivot table cannot produce this type of layout (i.e. header at the top and multiple aligned columns below it).
It would be great for those looking to make reports using Excel to be able to group low level data in a table. Business Objects, SQL Server Reporting Services, Access and lots of other MI reporitng apps can do this - by why cannot the worlds number 1 reporting software (Excel) do this?
Kenneth Barber commented
What do you mean by "multiple aligned columns"? Can you upload an example of your vision somewhere and give us the link?