Reverse Fill-down

[DKcrm]

Hi

Is there a ‘Reverse Fill-down’ function I still haven’t found, or can similar be obtained in an easy way?

In fill-down we would normally fill down values in a column from a populated field in all subsequent empty fields until next populated field appears.
In this case I want all duplicate fields cleared until next unique value appears - see example below.
Can this be done with existing functionality?

[dgudkov]

It can be done by creating a helper column in which similar values are enumerated from 1 to N. Then erasing all values where the count is not 1.

See the example below:

unfill-down.morph (2.3 KB)

[DKcrm]

Of course - simple and obvious.

Think I’ll go back to my coffee…