Add last value in same column

[Raulsousa]

HI

I have a table with three columns. Date|ValueA|ValueB.

There is a ValueA for each date. Most recent dates have no ValueB.

I would like the rows with no ValueB to assume the least (most recent) entry in ValueB

Any help on how to achieve this is most welcome.

[AlienSx · Accepted solution]

Hi, @Raulsousa . Sort by Date column then fill down ValueB column

[Raulsousa]

Thank you. That solved it