Use this module to fill empty cells with the content of adjacent rows.

Direction

  • Down: Fill empty cells with the nearest non-empty value above.
  • Up: Fill all empty cells with the nearest non-empty value below.

Example:
In the column 'Countries', some rows have missing values.

The 'Down' direction copies each country name to the blank rows after it:

The 'Up' direction sets each blank cell to the country name after it:

Did this answer your question?