Module 10
Fill down and report layouts
Fill down/up and turn report-style exports into tidy tables.
You'll be able to
- Fill grouped labels down
- Remove subtotal rows
- Tidy report exports
Lessons
- 1.Fill down and tidy report layoutsRepair report-style exports so every row stands on its own.
- 2.Fill up, and gaps that aren't nullFill labels in either direction and make sure the gaps are real nulls.
- 3.Turn section headings into a columnMove headings that are mixed into the data into their own column.
- 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
- beginner~6 minPro
Fill region labels down a printed report (retail)
The region is printed once per block. Fill it down so every store row has its region.
- beginner~6 minPro
Fill region labels down a printed report (franchise)
The region is printed once per block. Fill it down so every store row has its region.
- intermediate~8 minPro
Turn a report with subtotals into a clean table (retail)
Fill regions down and remove the Subtotal and Grand Total rows so only store rows remain.
- intermediate~8 minPro
Turn a report with subtotals into a clean table (franchise)
Fill regions down and remove the Subtotal and Grand Total rows so only store rows remain.
- beginner~6 minPro
Fill batch labels up a production sheet (bakery)
The batch number is printed on the last line of each batch block. Fill it upward so every line has its batch.
- beginner~6 minPro
Fill batch labels up a production sheet (brewery)
The batch number is printed on the last line of each batch block. Fill it upward so every line has its batch.
- intermediate~7 minPro
Fill down region and store labels together (retail)
The report prints Region once per region block and Store once per store block. Fill both down.
- intermediate~7 minPro
Fill down region and store labels together (pharmacies)
The report prints Region once per region block and Store once per store block. Fill both down.
- intermediate~7 minPro
Fill down labels whose blanks are empty text (volunteers)
Fill Down does nothing on this roster because the blank cells contain empty text, not null. Fix that first.
- intermediate~7 minPro
Fill down labels whose blanks are empty text (shifts)
Fill Down does nothing on this roster because the blank cells contain empty text, not null. Fix that first.
- intermediate~8 minPro
Turn a sideways report the right way round (new starters)
The report lists fields down the first column and one person per column. Make it one row per person.
- intermediate~8 minPro
Turn a sideways report the right way round (panel)
The report lists fields down the first column and one person per column. Make it one row per person.
- advanced~14 minPro
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".
- advanced~14 minPro
Combine two header rows into one (charity shops)
A sheet has years on the first row (printed once, over merged cells) and quarters on the second. Build headers like "2026 Q1".
- intermediate~8 minPro
Predict which rows Fill Down will change (stock take)
Before filling Group down, list the rows that will receive a value, and leave out rows Fill Down can't fill.
- intermediate~8 minPro
Predict which rows Fill Down will change (menu)
Before filling Group down, list the rows that will receive a value, and leave out rows Fill Down can't fill.