Unfill

<< Click to Display Table of Contents >>

Navigation:  Reference > Transforms >

Unfill

Description

Set adjacent cells with identical values to empty in selected columns.

 

Example

Unfill down all rows:

unfill-example

 

Unfill down all rows only where the value in the 'Country' column matches:

 

Unfill table example

 

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.

 

See also

Fill

Slide