Help Centre

Fill Down

About Fill Down

The Fill Down operation identifies blanks in selected columns and replaces them with the value from the row above. The fill down continues vertically until another value is encountered. The filled-down column will overwrite the original column.

Example

Fill Down is useful for dealing with tables where a category applying to a group of rows has been listed only in the first row of the group.

Input data
Output data
Year
Value
Year
Value
2019
100
2019
100
200
2019
200
300
2019
300
2020
400
2020
400
500
2020
500
600
2020
600

Using Fill Down

  1. Select ‘Fill Down’ in the operations menu.
  2. Select one or more columns to apply fill down to.