Power QueryExercises

Unpivot

Turning columns into attribute/value rows, for example one column per month into Month and Units rows.

Unpivot Other Columns keeps the identifier columns you select and turns every other column into rows, which means columns added next month are included automatically. Unpivot Columns does the opposite and breaks when new columns appear. Null cells produce no rows.

In the Power Query editor

Transform → Unpivot Columns, with Unpivot Other Columns and Unpivot Only Selected Columns in the menu.

Learn more

Related functions

Practise it

Related terms