Power Query (aka Get & Transform) has a Fill function that allows us to fill cells with the value above or below.
This helps when your data contains cells or rows with blank (null) values, and you want to copy down the value from the cell above.
To use the Fill function in the Power Query Editor:
- Right-click the column header of the column you want to fill.
- Select Fill > Down from the right-click menu.
The values will be filled down to replace the null values with the value above. The Fill function will NOT replace any existing values in the column. Once it hits a cell with a value, it will then look for the next blank cell and fill it with the value above.
I also have an article on how to fill blank cells horizontally across rows.
Please leave a comment below with any questions.