Merging Rows to Get Complete Names

Hi, do you mean name always span across A1:A3, desig in B1 and email in C1; then you would like merge A1 thru A3 by concatenating the 3 cells with a space in between?

Does the desig and email already merged? e.g. desig in B1 is actually merged cells of B1:B3 and email in C1 is actually merged cells of C1:C3?

Does your data start from row 1?


_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin

Yes. you have got it almost right
1. Data starts from row 2 as row is header
2. The name column sometimes span across A1:A3 and sometimes A1:A2 . If first name, middle name and last name then A1:A3 if First Name and Last Name then A1:A2
3. Design and Email columns are already merged B1:B2 or B1:B3 & C1:C2 or C1:C3 depending on number of rows used for namemerge.JPG

Hope this helps!