I have data that looks like the example below:
fistname, last name, multiple rows, each with different data
RON SMITH App
RON SMITH Box
RON SMITH Cat
RON SMITH Dog
RON SMITH Hop


My merge program reads data like the sample below:
First name. last name, one row, but multiple cells, each with different data.

RON SMITH App Box Cat Dog Hop

Can someone tell me the best way to convert my existing data into the format
above?

Any help is much appreciated.

Thanks
R