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,
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,