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.

Using Fill Down

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

See a fully-worked example in the Stack Grids and Fill Down tutorial