Description
Set adjacent cells with identical values to empty in selected columns.
Example
Unfill down all rows:
Unfill down all rows only where the value in the 'Country' column matches:
Inputs
One.
Options
•Check the column(s) you wish to unfill.
•Select Direction depending on the direction you wish to unfill to.
•Set For to Rows with same key value, if you wish to only unfill up/or down when when 2 adjacent rows have the same value in the Key column column.
Notes
•Matching for Rows with same key value is sensitive to case and whitespace.
•You can delete rows left empty using Filter and columns left empty using Remove Cols.
•To fill empty values with something else use the Replace transform.
See also
•Fill