Reverse Fill-down


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?


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)


Of course - simple and obvious. :smile:

Think I’ll go back to my coffee…

1 Like