Slide

<< Click to Display Table of Contents >>

Navigation:  Reference > Transforms >

Slide

Description

Move non-empty values in selected columns to adjacent non-empty cells.

 

Example

Move all non-empty values to the top:

 

Move all non-empty values to the top of the table.

 

Inputs

One.

 

Options

Check the column(s) you wish to move values in.

Select Direction depending on the direction you wish to move values.

 

Notes

Cells containing whitespace are not considered empty.

You can delete rows left empty using Filter. and column left empty using Remove Cols.

 

See also

Offset

Fill

Whitespace