How to convert an outlined (Grouped/Staked) Data sheet into a tabular formate ?

[Ahmedfouad2016]

Hi There , need your help please

I have a set of data stacked or grouped in tree structured outline , i need to unfolde it all to a regular tabular format in order to be able to use in pivot table analysis

I have attached how it currently looks and how I need it to look line

Many thanks for your help

[mikeTRON]

Do you not have access to the source data that the pivot uses to create the original view?

Otherwise you can use the formulas I have in the workbook, then you will need to filter out BLANKS on Volume column and Copy & Paste to the new sheet. Then you can use a pivot table to slice and dice on the information if you want.

[Ahmedfouad2016]

Hi mikeTRON
You are amazing , thank you very much for taking the time to put together the equations for me
I will go through it and apply it on my original Sheet


To answer your question, yes i have the original software bu this is how it export the data to excel , i am able to get a better outcomes with normal slicers in all directions

once again
Thanks a million for your Help , really appreciate it