Power QueryExercises

Reshape month-and-measure columns into a tidy table (stalls)

Columns look like "2026-01 Sales" and "2026-01 Units". Produce one row per item and month with Sales and Units columns.

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

About this exercise

What you'll practise

Combine unpivot, split and pivot to reshape a two-part header.

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)
    • Item: text
    • 2026-01 Sales: number
    • 2026-01 Units: number
    • 2026-02 Sales: number
    • 2026-02 Units: number

Expected output columns

Item (text), Month (text), Sales (number), Units (number)