how to unpivot a pivotted excel sheet?

D

Dave Peterson

Is this based on a range/table in a worksheet?

Find the grandtotal cell
double click on it.

You'll see the data--but it won't be formatted pretty.
 

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

Unpivoting a worksheet 6
Power Pivot. Yikes. 0
Dealing with a Pivot Table (when I don't want to) 0
Pivot Table cell values 1
Unpivot 1
Excel --> Word 4
Write back from pivot table 1
Write back from pivot table 0

Top