Unpivot an Excel matrix/pivot-table?

by

Oh, well, it’s a little complicated.
One of the problems is, the wizard-callup shortcuts don’t work in non-english versions of excels (damn, at home I would have the English version, but here at work…)

Here’s a good video:
https://www.youtube.com/watch?v=pUXJLzqlEPk

But youtube videos can be deleted, so to make it a solid SO answer:

First, you need to go to “Options”, and add the menuband-item “Pivot table and PivotChart Wizard”.

Options

Wizard

Create a multiple consolidation pivot table
Multiple-consolid

and use the custom variant
custom variant

and select the range, and in new work sheet
range

then delete rows and columns fields

delete rows and columns

Double click on the NUMBER (54 in the picture)

values consolidtions

and excel will give you the halfway normalized data.

halfway

More Related Contents:

  1. Convert matrix to 3-column table (‘reverse pivot’, ‘unpivot’, ‘flatten’, ‘normalize’)
  2. Aggregate, Collate and Transpose rows into columns
  3. Excel: Formulas for converting data among column / row / matrix
  4. how should I apply a formula and get answer in all the odd cells?
  5. Sequence of numbers based on start and end value of 2 cells [closed]
  6. Function to convert column number to letter?
  7. Vlookup using 2 columns to reference another
  8. Better way to find last used row
  9. 2 Dimensional array from range [closed]
  10. Using Google Chrome in Selenium VBA (Installation Steps)
  11. Excel formula to get cell color [duplicate]
  12. Dir() function not working in Mac Excel 2011 VBA
  13. How to use workbook.saveas with automatic Overwrite
  14. Range limit conundrum
  15. Using LocationTextExtractionStrategy in itextSharp for text coordinate
  16. How do you run a .exe with parameters using vba’s shell()?
  17. Mysql Convert Column to row (Pivot table )
  18. How to use FindWindow to find a visible or invisible window with a partial name in VBA
  19. How do you get a Range to return its Name?
  20. Passing variable from Form to Module in VBA
  21. Excel VBA: Convert a date string to a Unix timestamp
  22. excel to pdf ignores print area and calls printer
  23. Insert picture into Excel cell [closed]
  24. Leave out quotes when copying from cell
  25. Excel VBA – exit for loop
  26. CountIf With Filtered Data
  27. Converting a string representation of a constant into a constant?
  28. VBA WinHTTP to download file from password proteced https website
  29. Create folder path if does not exist (saving from VBA)
  30. How to fix a VBA “type mismatch” error after switching to 64-bit Excel

Leave a Comment