Table.FillDown
Table function · By Tahir Nas · Examples run in our simulator · Published · Updated
Replaces nulls with the value above.
When to use it
Use it for report layouts where a group label appears only on the first row of its block. Make sure the blank cells are null first; empty text isn't filled.
Syntax
Table.FillDown(table as table, columns as list) as tableParameters
- columns
- Columns to fill.
Returns
The filled table.
Example
Table.FillDown(#table({"Region", "Store"}, {{"North", "A"}, {null, "B"}, {"South", "C"}, {null, "D"}}), {"Region"})Result
| Region | Store |
|---|---|
| North | A |
| North | B |
| South | C |
| South | D |
Example: turn blanks into null, then fill
Empty strings aren't null, so replace them before filling down.
Table.FillDown(Table.ReplaceValue(#table({"Region", "Store"}, {{"North", "A"}, {"", "B"}}), "", null, Replacer.ReplaceValue, {"Region"}), {"Region"})Result
| Region | Store |
|---|---|
| North | A |
| North | B |
Both results are produced by the Power Query Exercises simulator, an independent implementation of a documented subset of M, and checked on every build.
Good to know
- Only null is filled, not empty text.
Common mistakes
- Filling down before sorting is fixed, so labels attach to the wrong rows.
- Expecting empty text to be filled.
The matching command in Excel
- Excel for Windows
- Right-click the column header > Fill > Down
- What you see
- Nulls below a value take that value until the next value.
Paths are for the Power Query editor in Excel for Microsoft 365, checked against Microsoft's documentation on 8 November 2026: Fill values in a column (Microsoft Learn).
Exercises that use Table.FillDown
- 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.
- 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 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.
- 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".
- 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.
Learn more
Related functions
Official documentation: Table.FillDown on Microsoft Learn.