How to convert pivot table data in to regular table data ?

[nilesh1foru]

I am using excel 2010 and I have converted my data into pivot table.

I have done the analysis and I want my data back to

orignal format without grouping or any other stuff.


How to convert pivot table into orignal table.

 

[vijaySharma]

Hi Nilesh,


Welcome to Chandorg Forums.


You may double click on the data cells and the pivot table will generate the raw data in a separate sheet.


This however is dependant on few settings for the pivot tables.


I would recommend double clicking on the grand total row OR columns


HTH

~VijaySharma