Hello and thank you for the very quick response and solution. I tested it and can see that it is almost there. I think I was incomplete in my example - While the info I gave described what I am trying to do - the characters in each column position were representing the contents of each cell (i.e. in reality - each cell can have multiple characters).

I created and have attached here a mockup of the data file which more accurately represents the source data. I also loaded and ran your suggested macro. I can see that it is doing the concatenation as I had hoped (brilliant!) - unfortunately it is parsing out the contents of each original cell into separate columns. Sorry for the incomplete specs. Would it take much further modification to avoid the cell parsing and move each cell content intact?

Thanks again for your support!

Data Merge Test v2.xlsm