Hi,
I am looking to convert some data in Excel to have multiple subtotals based on 3 grouping levels. I have to convert Picture 1 to Picture 2:
Picture 1:
| Sl no | A | B | C | Grouping 1 | Grouping 2 | Grouping 3 |
| 1 | 3 | 1 | 2 | Eden | Tom | Harry |
| 2 | 4 | 2 | 3 | Eden | Tom | Gary |
| 3 | 5 | 3 | 4 | Eden | Jerry | Mia |
| 4 | 6 | 4 | 5 | Garden | Pete | Joey |
| 5 | 7 | 5 | 6 | Garden | Beck | Kia |
Picture 2:
| Sl no | A | B | C |
| Eden | | | |
| Tom | | | |
| Harry | | | |
| 1 | 3 | 1 | 2 |
| Totals: Harry | 3 | 1 | 2 |
| 2 | 4 | 2 | 3 |
| Gary | | | |
| Totals: Gary | 4 | 2 | 3 |
| Totals: Tom | 7 | 3 | 5 |
| Jerry | | | |
| Mia | | | |
| 3 | 5 | 3 | 4 |
| Totals: Mia | 5 | 3 | 4 |
| Totals: Jerry | 5 | 3 | 4 |
| Totals: Eden | 12 | 6 | 9 |
| Garden | | | |
| Pete | | | |
| Joey | | | |
| 4 | 6 | 4 | 5 |
| Totals: Joey | 6 | 4 | 5 |
| 5 | 7 | 5 | 6 |
| Totals: Pete | 6 | 4 | 5 |
| Beck | | | |
| Kia | | | |
| 5 | 7 | 5 | 6 |
| Totals: Kia | 7 | 5 | 6 |
| Totals: Beck | 7 | 5 | 6 |
| Totals: Garden | 13 | 9 | 11 |
Any help will be much appreciated!
