Fill down
Replacing nulls with the nearest value above, used to repair report layouts that print a label once per group.
Fill Down only replaces null, not empty text, so blank cells from Excel may need Replace Values first. It depends on row order, so it belongs before any sort that would separate a label from its rows. Fill Up works the same way from below.
In the Power Query editor
Transform → Fill → Down, which writes Table.FillDown.
Learn more
Related functions
Practise it
- 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.
- 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.
- 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.
- 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.