Power QueryExercises

Module 10

Fill down and report layouts

Fill down/up and turn report-style exports into tidy tables.

You'll be able to

Lessons

  1. 1.Fill down and tidy report layoutsRepair report-style exports so every row stands on its own.
  2. 2.Fill up, and gaps that aren't nullFill labels in either direction and make sure the gaps are real nulls.
  3. 3.Turn section headings into a columnMove headings that are mixed into the data into their own column.
  4. 4.Combine two header rows into column namesBuild clean column names from a multi-row header without typing them.

Take the fill down and report layouts quiz (8 questions)

Exercises