The following videos walk through how to do the unpivot transformation using Power Query for each of the raw data formats above. That technique creates a Multiple Consolidation Range pivot table, then uses its Show Details feature to “unpivot” the data. Download unpivot.zip and unzip it into unpivot.xlsx. If you have a simple data set, you can manually upivot the data, and there are instructions here. In Excel 2011 for mac, a PivotTable is a special kind of table that summarizes data from a table, data range, or database external to the workbook.If you’re PivotTable aficionado, you will be in seventh heaven with the new PivotTable capabilities in Office 2011 for Mac.

Use VBA add-ins and macros that you developed for Office for Windows with Office for Mac.

To “reverse pivot”, “unpivot” or “flatten”: For Excel 2003: Activate any cell in your summary table and choose Data - PivotTable and PivotChart Report: For later versions access the Wizard with Alt+D, P.