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)