Excel Tool

Order Online
Our company contact information There you can find frequently asked questions and answers

Home | Products |Purchase | FAQ | Contact Us | Useful Resources

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.

Results:


Also see this example:

Convert Flat Table to Crosstab (Pivot Table).

Copyright © 2001-2014 Excel-Tool All Rights Reserved.

Copyright Excel-Tool All rights reserved