Complete a column using the last complete value and values from another column

[technocrat]

Great. Please mark the solution for the benefit of those to follow.