Power QueryExercises

Module 14

Pivot and unpivot

Reshape wide and long tables and survive new columns on refresh.

You'll be able to

Lessons

  1. 1.Unpivot columns so new months are picked upTurn wide data long in a way that survives new columns.
  2. 2.Pivot a column with an aggregationPivot long data into a cross-tab with the right row grain.
  3. 3.Pivot without aggregation and the duplicate errorDiagnose and fix duplicate key/value pairs before or during a pivot.
  4. 4.Unpivot, then turn header text into real datesTurn unpivoted header text into typed dates that survive new periods.

Take the pivot and unpivot quiz (8 questions)

Exercises