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.
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.