Unpivot columns

In Power Query, you can transform selected columns into attribute-value pairs where columns become rows. You unpivot columns in the Query Editor.

ShowLearn more about the Query Editor

You can access the Query Editor from the Navigator pane when connecting to a data source, or at any time from the Workbook Queries pane or the contextual Query ribbon tab for an existing query. To learn how to load the Query Editor, see Power Query Quick Start.

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, Excel 2010