Help me pivot the pivot table back!
June 20, 2012 1:20 PM Subscribe
How to reformat pivot table data so that it works like any other spreadsheet? Simple instructions needed.
posted by Frowner to computers & internet (6 answers total) 2 users marked this as a favorite
Here is the deal: I know nothing of pivot tables. Someone else gave me a spreadsheet with the raw data and the pivot table; my boss wants me to cut some lines out of the pivot table so that we can recalculate the numbers. However, I can't do this. Also, the source data does not actually include all the lines that appear on the pivot table, so I don't understand how to modify it to get the desired results.
IE, on the pivot table, it shows that four cats each have a climbing tower and a cardboard box. But on the raw data, it shows that while all four cats have climbing towers, only two cats have cardboard boxes. So I don't even know where the "all four cats have cardboard boxes" data is coming from on the pivot table.
What I would like to do is copy the pivot table in some way that turns in into just a regular spreadsheet that I can manipulate - delete numbers, delete lines, etc. (We would like to do calculations based only on the number of climbing towers and subtract all the cardboard box lines.)
Can I do this? If so, how? Please give me very simple "and then you highlight the lines"-level instructions, as I have not used excel for anything more complicated than basic formulas before.