Add last value in same column

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.