Pivot
Turning distinct values of one column into new columns, filled from a value column with an aggregation.
Pivoting is usually the last step for presentation, because analysis tools work best with long tables. Without an aggregation, two source rows for the same cell produce an error. New distinct values become new columns automatically if the pivot values come from the data.
In the Power Query editor
Transform → Pivot Column, with Advanced options for the aggregation.
Learn more
Related functions
Practise it
- advanced~10 minPro
Pivot order statuses into columns (kite shop)
Count orders per region with one column per status (Complete, Cancelled, Pending).
- intermediate~9 minPro
Pivot months into columns, summing repeated entries (bakeries)
Each store can have several sales lines per month. Pivot Month into columns with the total Sales per store and month.
- intermediate~8 minPro
Turn attribute–value rows into one row per record (intake)
A form tool stores answers as (RecordID, Field, Value) rows. Pivot Field so each record becomes one row.
- advanced~12 minPro
Pivot categories and add a total that includes future columns (consultancy)
Pivot expense categories into columns (summing amounts), then add a Total across every category column, including new ones.