About EasyMorph Tutorials & Examples Web-help

Reverse Fill-down

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?

image

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)

1 Like

Of course - simple and obvious. :smile:

Think I’ll go back to my coffee…

1 Like
To learn more about EasyMorph visit easymorph.com.