Put this in D2 and drag down (double click the cell handler)
=IF(A2="",D3,A2)
Now Column D needs to be copy Paste special value to column A.

Finally delete column D