Return Last non null value from other column

[Mina Mahmoodi]

I need to get the last non null value from other column like the file attached

[Gaia Paolini]

The values in yellow do not appear anywhere else on the file. Can you clarify the example