Hi All, I am new to this forum & looking forward to your help.
I have a very lengthy excel sheet which runs over more than 350 rows & about 200 columns.

Also, I have about 100 sub-groups of the columns & 20 groups of these sub-group. I will also have Month & teams as indicators on row of the sheet. I need to generate a pivot & populate these groups & sub-groups in a pivot in such a way that when some wants to have a drill down look of the group then only sub-groups are made visible. & only when clicked on sub-groups the individual smaller groups are been displayed.

Please have a look at attached file - when I have tired to explain through color codes of what data gets filled-up where. Please let me know if you have any question in understanding the data.

What I need is that kind of pivot table which can help populating data vertically so as to take care of different teams & the month-wise irrespective of the teams.

thanks in advance for your having a look at this. Do let me know if such requirement cannot be done even with the complex formula like "V & H looks-up". Thanks for reading this.

The file to explain what exactly is needed.
Example.xlsx