Undo a Pivot Table

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?
 
F

Frank Kabel

Hi
haven't they included the raw data?. If not, this is nearly impossible
as you only have the aggregated information!
 
D

Debra Dalgleish

Double-click on the Grand Total cell, and it should send the data to a
new worksheet.
 
Top