A Must have for every Controller !
Excel Reverse Pivot is a professional Excel AddIn to convert pivot data into normal data structure / table. Exporting the data into CSV file is also possible
- Convert pivot tabele into normal data table
- setup as many conversion profiles you need
- convert pivot data over a existing profile
- convert as many pivot tables into one result data structure as you like with one click
- use sheet name prefixes to include specific sheets in the conversion process
- use named seperators in the sheet names to identify values for the result table (e.g. "{4080}_TableCosts" as sheetname) - then value '4080' is transferred into each row of the result table
- store the export schema for CSV export in each profile
- choose the ranges to convert over range picker
- export the data into every folder
- all settings are saved
- user interface and dialogs in german
- possible to run on TerminalServer
- and more...
free DEMO-Download for Windows
Operating system
WINDOWS (compatible with Excel 2007 - 2016):
Windows XP x32, Windows XP x64,
Windows 7 32 Bit, Windows 7 64 Bit, Windows 8, Windows 8.1, Windows 10
Office-system 32 Bit
Demoversion has complete functionality, limited to 5 rows export by each pivot column
Demo-Video: “How to convert pivot table into normal data table” (language: german)