I have an excel file with n rows of data. I need to compile the data onto a separate sheet into n number of tables. Here is what I mean:
The main data file has three category columns. I need to do the following:
1. First, look at the unique values in category1
2. For each unique value I need to find the unique values in category2 and then category 3 and sum them up.
3. I need to then build a table on anoter sheet for each of the unique values in category 1.
Please see the attached sample for the initial data and the resulting tables.