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:
(c) 2023 Altair Engineering Inc. All Rights Reserved.