0 - 1 of 1 tags for group id

Hi,
I have a table with Columns A, B below but I want to create Column C

Column C is explained as follows: Ordering by Column A ASC I want to replicate the value od Column B for all succeeding rows until a Non-Null value is met, then start again.