Power QueryExercises

Combine two header rows into one (franchise)

A sheet has years on the first row (printed once, over merged cells) and quarters on the second. Build headers like "2026 Q1".

Level
advanced
Time
~14 min
Task
Build the query
Access
Pro
Checking your access…

About this exercise

What you'll practise

Rebuild column names from a two-level header with transpose and fill down, so new years work too.

The scenario, sample data, step list, hints and solution open with Pro. Grading checks your query against hidden data as well as the visible sample, so a query that only fits the sample doesn't pass.

Input

  • Sheet (table)
    • Column1: text (nullable)
    • Column2: number or text
    • Column3: number or text (nullable)
    • Column4: number or text (nullable)
    • Column5: number or text (nullable)

Expected output columns

Region (text), 2025 Q1 (number), 2025 Q2 (number), 2025 Q3 (number), 2025 Q4 (number)