We help IT Professionals succeed at work.
Troubleshooting Question

How do I get the data from an Excel pivot table

42 Views
Last Modified: 2020-10-21
I have been sent a pivot table in an Excel spreadsheet.  This was produced by a database application.  We want to get to the actual data file.  There is no obvious data file in a tab on the spreadsheet, but it seems that the data must be in there somewhere because I can manipulate the pivot table.
Is it possible to somehow reverse the pivot table to get a simple spreadsheet list of the data table.
Comment
Watch Question

Excel & VBA Expert
CERTIFIED EXPERT
Most Valuable Expert 2018
Awarded 2015
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION