Unpivot columns

In Power Query, you can transform selected columns into attribute-value pairs where columns become rows.

To Unpivot columns

  1. Select one or more columns.

Select Unpivot columns

Using the Query Editor ribbon

  1. In the Query Editor ribbon, click Unpivot Columns.

Using the Query Editor context menu

  1. Right-click the selected columns, and click Unpivot Columns.

Unpivot Columns creates an Attribute column for each selected column heading and a Value column for each selected column cell value. The attribute-value pair columns are inserted after the last column. In the example above, each date column becomes a row with an Attribute column containing the date value and a Value column containing the date column value. If you add an additional date column to the original source table, Power Query adds an additional row to the Unpivot table.

Unpivot columns sample results

Top of Page Top of Page

 
 
Applies to:
Excel 2013, Power BI for Office 365, Excel 2010