Reshape month-and-measure columns into a tidy table (kiosks)
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)