I need to merge two columns, A & B, and only B has data which I
obviously want to preserve.
I have tried merging A1 & B1 and doing a "Paste Special" for the rest
of the column, but it leaves me with a blank, merged cell.

How can I make this into a single column while preserving the data I
already have?

Thanks to all