Firs not null cell

[beacc]

Dear all,

I want to add a column where I have the first not null value. Something like this:

The thing is that the value will depend of the file and probably will not be at the same position, for example the first not null cell is in row 5 but then is possible that the first is in the row 3.

Thank you all

[JamesCharnley · Accepted solution]

@beacc you can filter out non-null rows and use the sample tool to find the first instance of a non-null when it's sorted by RecordID, which you can then append to all rows as in your requested output.

[binuacs]

@beacc One way of doing this

[BS_THE_ANALYST]

Here's one way!

[Hamder83]

Sorry this is not the cleanest. But it works :D 

[RobertOdera]

Hi, @beacc 

Plenty of ways to get this done. Enjoy!

[beacc]

Thank you all :)