Convert Pivot table back to Data Table

[Samaa]

I have a Pivot table but i don't have the data source used to create it, i
want to convert it back to a normal data table. how can i do this?

 

[Manoj]

Double clicking on any cell of the pivot table will give you the underlying
data adding up to that cell. in case you want the entire data just go to the
grand total cell of the pivot and double click the same. it will open up
another sheet and list out the entire data.

Trust this works for you.

Regards,

Manoj

 

[Samaa]

It did, Thank you very much

Double clicking on any cell of the pivot table will give you the underlying
data adding up to that cell. in case you want the entire data just go to the
grand total cell of the pivot and double click the same. it will open up
another sheet and list out the entire data.

Trust this works for you.

Regards,

Manoj