Altair® Monarch®

 

Ditto

Description

Replace empty cells with the value of the first non-empty cell above it.

INPUT/Output DATA TYPE

Input

Output

text, numeric

text, numeric

 

example

In this example, the Media column has empty cells, as shown below:

 

We can use Ditto to transform the column into something like this: