Convert Pivot Table to Table

[Adrae]

I have summarized a large datasource (60 thousand rows) using a pivot table.

I now want to turn that back into a spreadsheet to be resummarized. The reason is that the end user cannot manage a workbook the size of the one with 60 thousand rows.

My problem is that if I paste values for the pivot table, I have to manually populate down each column. For example, Column as has three values...North America, Europe & Asia. But since I copied from a pivot table only A1 says North America and then I have to copy it down stopping at Europr and repeat for Europe.

If it was just the regions, that mght be manageable, but I have around 6 columns like this, some with MANY variations.

QUESTION: How do I take a pivot table and make it look just like a regular excel table....(all cells populated automatically)?

Thanks,

[Andrew Poulsom]

Select all 6 columns and choose Edit|Go To|Special, check blanks and click OK. Type =, press the up arrow and press Ctrl+Enter (that's hold down Ctrl and press the Enter key). You can convert those formulas to values afterwrds if you want. Oh, and you may need to tidy up the last row.