Copy/Move data from one column to another without overwriting

Hi,
I have a large spreadsheet which I have extracted the data I need, but I am now having a problem tiding it up.
To simplify. I have 2 columns, both containing data formatted as text, each column has some data, but on different rows.
I need to merge the 2 columns without overwriting the data on the second column, with blank data from the first column, and without the column shrinking or growing. (hope that makes sense !)
Here is a section of my spreadsheet that needs merging:

Excel-1.PNG

I have tried copy > Paste Special > Skip Blanks, but it just copies the column to the other - no merging.

I am not very VB savvy, so would prefer it if there was an answer without resorting to macros.

Regards,
Paul

please attach sample sheet