Description
Fill empty cells in selected columns with the adjacent non-empty values.
Examples
Fill down all rows:
Fill down all rows only where the value in the 'Id' column matches:
Inputs
One.
Options
•Check the column(s) you wish to fill.
•Select Direction depending on the direction you wish to fill to.
•Set For to Rows with same key value, if you wish to only fill up/or down when when 2 adjacent rows have the same value in the Key column column.
Notes
•Cells containing whitespace are not considered empty.
•Matching for Rows with same key value is sensitive to case and whitespace.
•To fill empty values with something else use the Replace transform.