Fill in cells with a value based on a neighbouring column

Dear All,

I attach a very simple excel file with an issue
I have 2 columns, the second column has some empty cells in the end of the column
What I would like to do is to fill in those empty cells but only as many as the filled-in cells in the first column

(I have already tried the specialcells(xlCellTypeBlanks) but that did not work as the empty cells are not always "blank" as well)

Could you please help?
Many thanks