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