Unpivot table (Unpivot)

Range > Unpivot cross-table into flat one

This utility converts a crosstab (pivot) table into a "flat" (standard) table.

This procedure is called "data straightening" (unpivot data) . As a result of such "straightening" we get a table where all similar data are in one column.

The utility will insert a new sheet into your workbook with the name "UnPivoted Table" , and then copies the table there in a standard format. You can edit the converted table or add new data and "collapse" it again using the "Pivot Tables" tool.

Screenshot

Running this tool

Click YLC Utilities > Range > Unpivot cross-table into flat one :

How much time will this save?

Using this tool will definitely save you time and effort. However, the actual time savings will depend on how often you use it. Excel , the amount of data you work with, and how often you use this tool.

Download the extension

You can use the utility Unpivot cross-table into flat one by installing the extension YLC Utilities .

After that, this function will be available in all files that will be opened in Excel .