Fill

<< Click to Display Table of Contents >>

Navigation:  Reference > Transforms >

Fill

Description

Fill empty cells in selected columns with the adjacent non-empty values.

 

Example

Fill down:

 

how to fill down empty values example

 

Inputs

One.

 

Options

Check the column(s) you wish to fill.

Select Direction depending on the direction you wish to fill to.

 

Notes

Cells containing whitespace are not considered empty.

To fill empty values with something else use the Replace transform.

 

See also

Unfill

Slide

Whitespace

Impute