What is it?
The fill empty cells with filter can be used to populate a column of empty cells with either a predefined value or the values of rows in the same column.
How is it used?
Add Table Filter > Fill, Replace & Overwrite > Fill Empty Cells With …
This filter comes with three modes; Set to value of previous row, Set to value of next row or Set to state value.
The previous and next row options will copy the values of those rows and populate every cell in a specified column unless there is text is present.
For the static option, this is a simple way to fill an entire column with one specific value.