Description
Move non-empty values in selected columns to adjacent non-empty cells.
Examples
Move all non-empty values to the top:
Move all non-empty values to the top within rows of same priority:
Inputs
One.
Options
•Check the column(s) you wish to move values in.
•Select Direction depending on the direction you wish to move values.
•Set For to Rows with same key value, if you wish to only slide 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.
•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