How can i UNPivot a pivot table to retrieve all of the data in Tabular form> excel 2013?

[Jeffrey Green]

All we got from the client is the final pivot table, we do not the source tabular data. Can I UNpivot it to get back to my raw data?

thanks

Jeff

 

[V_Malkoti]

Double click on Grand Total row.

 

[hiker95]

Jeffrey Green,

There is a lot of information on the web if you do a search for unpivot a pivot table in excel

 

[Jeffrey Green]

yes, but all i could find was Save a CSV, or other things . . . i never came across this . . .
This solves the issue, thanks!!