Sumarize Column Itens to Row itens, to ease any PivotTable operation

Hello everybody! o/

I remember I saw the solution of this issue in somewhere I don't remeber and can't find anymore =/


I have this table (the months are displayed across the columns; and, as you know, it is not functional for pivotTables... )






So..... I want to turn the table aforementioned into this one look-alike (Oh yeah!!! know the data is organized in a way i can easily go through with the PivotTables \o/ )




Thank you a lot!


An example: View attachment Examplo_sumarizeColumn.xlsx

Perhaps something like this? please see the file attach

Regards
Rizky

you could unwind it in a pivot table or through power query.

to do it in a pivot table:

1. click in the table and hit ALT D P
2. select multiple consolidation ranges and click next
3. create a single page field, click next
4. select the table including the column headers and click Add then next
5. new worksheet....finish

you should have a pivottable with all the data.....find the grand total value and double click it

then just clean up the columns and change the column headers.

you can do the same thing a little easier in power query but you'd need to install it if you don't have it.
the instructions above should work in all versions.

Theres a few videos on youtube on how to do it also. just search on 'Learn Excel - Unwind Pivot Data - Podcast 1787'
it would probably be a little clearer then my simple explanation.

Thank you Weazel!

This solution is great!

That's exactly the video of Bill Jelen that I saw and didn't remember!

Here is the solution with PowerQuery: https://www.youtube.com/watch?v=yX-QNxaOj9c


THanks a lot! =D