Hi -
Is it possible to easily convert pivot table data into a "regular" format? Someone has sent me a pivot table, but for what I need to do, I really need just a spreadsheet with the data so I can sort and filter it for my needs and write some formulas to call on the data.
I was given something like in the first screen shot here:
pivot_1.jpg
And I want to convert it easily to a "regular" view like this:
pivot_2.jpg
For the sample above, I had to copy and paste things to make it work, but there must be a simpler way. I did a Google search and a forum search, and I keep getting directed to this article:
http://j-walk.com/ss/excel/usertips/tip068.htm Unfortunately, I followed the steps but it didn't help.
I figure there must be a way to do this, but I am not wording my searches correctly to find the steps. Thanks for whatever help you can provide.
Bookmarks