I need to copy a list of data in single cell format into a spreadsheet where
those same columns are merged cells (with four cells merged into one).

I have several hundred lines of data so some way of copy & paste (other than
each cell individually) would be appreciated.

Thanks

Paul