Power QueryExercises

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