Unpivot

  • Thread starter Thread starter Rich C
  • Start date Start date
R

Rich C

Is there a way to take a pivot table and 'unpivot' it back
to a normal spreadsheet?
 
Rich,

A pivot table is not a converted sheet -- it's based on some cells. If you
right-click it, Wizard, then go back a step or two in the wizard, you can
see the reference to the cells from which the pivot table is built.
 
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

how to unpivot a pivotted excel sheet? 1
Unpivoting a worksheet 6
Pivot Table 4
"Unpivot Technique" - Changing a Table Into A List 1
reformating data for Excel pivot tables 2
Removing Pivot Table Functionality 1
Pivot Table Defaults 1
Pivot Table - copy specified Grand Totals 1

Back
Top