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

Applies To: Excel 2013, Excel 2010

Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language