Power QueryExercises

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