Forum Discussion
Solved
Excel Formula Problem
Hi, I have an excel sheet with thousands of rows four individual persons and hundreds of columns of categories. Each four consecutive columns can be clubbed as category. I want to do an analysis of t...
For best analysis change your structure from crosstabular form into a flat table:
Person - Category - Sub - Type - Value
Then it is just a matter of a quick pivot table.
Haris1234 Since you mention "thousands of rows and hundreds of columns" I'd suggest you take a look at Power Query to flatten your data, as suggested by Detlef_Lewin .
From there, you can create the desired output within Power Query, in Power Pivot (Data Model) or in a regular pivot table.
All of these are demonstrated in the attached file.