| Contact Us |
Convert Crosstab / Pivot Table to Flat Table (List)
With the Unpivot Table tool you can convert Crosstab / Pivot Table into Flat Table (a one-dimensional list) for better understanding / analyzing of your data.
So that the result would look similar to this:
Tool location: Add-Ins →Excel Tool Box → Convert Crosstab to Flat Table: Shortcuts: (Alt + X + X + N )
The sample table: Convert Crosstab to Flat Table.xlsx
Open the pane by clicking on: Add-Ins →Excel Tool Box → Convert Crosstab to Flat Table or pressing the Shortcuts: (Alt + X + X + N ).
1. Click the 'OK' button.
Also see this example: