Excel: Pivot Tables into static tables
To convert a pivot table into a static table:
Select the Pivot Table.
Paste Special (ALT-E-S).
Choose "Values and number formats":
To convert a pivot table into a static table:
Select the Pivot Table.
Paste Special (ALT-E-S).
Choose "Values and number formats":