Convert Pivot table back to Data Table
 

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?

Convert Pivot table back to Data Table
 

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" wrote:

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?

Convert Pivot table back to Data Table
 

It did, Thank you very much

"Manoj" wrote:

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" wrote:

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?