how do i merge cells but not rows

[pvdbijl]

would like to merge a title, first, last name, within a row but avoid merging
all the rows within a mailing list.

 

[JE McGimpsey]

For an in-place solution, one way:

http://www.mcgimpsey.com/excel/mergedata.html