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:

 

 

 

© 2024 Altair Engineering Inc. All Rights Reserved.

Intellectual Property Rights Notice | Technical Support