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
- intermediate~8 minPro
Unpivot month columns into rows (hardware)
Turn one column per month into Month and Units rows, in a way that picks up new months automatically.
- advanced~10 minPro
Unpivot only the quarter columns, whatever else the sheet has (budget)
The sheet has quarter columns (Q1 2026 …) and descriptive columns that change over time. Unpivot just the quarters.
- advanced~15 minPro
Reshape month-and-measure columns into a tidy table (kiosks)
Columns look like "2026-01 Sales" and "2026-01 Units". Produce one row per item and month with Sales and Units columns.
- advanced~10 minPro
Predict which cells an unpivot will drop (stock sheet)
Before unpivoting a sheet with blank (null) cells, list exactly the item–month cells that will disappear.