Undo a Pivot Table

  • Thread starter Thread starter JB
  • Start date Start date
J

JB

I received a spreadsheet from a client... they have
summarized all of the information into a pivot table.

I need to revert the Pivot Table back to the raw data
layout so that I can analyze the information.

Is this possible?
 
Hi
haven't they included the raw data?. If not, this is nearly impossible
as you only have the aggregated information!
 
Double-click on the Grand Total cell, and it should send the data to a
new worksheet.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table - undo of a macro 1
Pivot table question 1
Undo "Convert to formulas" pivot function 1
Excel 2003 Pivot Table Issues 3
Pivot Table - Changes 5
Value filter missing in pivot table 3
including zero values in a pivot table 2
Question on the occupied field of the pivot table in excel spreadsheet 0

Back
Top