|
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:
