Altair® Monarch®

 

Empty Cells with Value Above

Description

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

INPUT/Output DATA TYPE

Input

text

Output

text

example

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

We can use Replace Empty Cells with Value Above to transform the column into something like this: