Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

How do I merge columns but keep the content in both?

I'm using Numbers '09.


If I have first names in column A and last names in column B...how do I combine both into column A to look like this: Last Name, First Name (ex: Doe, John)?


Thanks,


Mark

iMac, Mac OS X (10.7)

Posted on Sep 1, 2011 4:32 PM

Question marked as Best reply

Posted on Sep 1, 2011 4:48 PM

m,


First, add a new column "before" the existing column A. It's not possible to combine the current content of A with the current content of B and have them appear in the place of the original Column A data. So, we add a new column for the combination. If you don't want to continue to display the original First Name data hide that column.


When you combine two character strings, it's called Concatenation. There's a concatenation operator and a concatenation function. You can use either. Here are examples that meet your spec:


In the first data row of the new column A, write: =C&", "&B


Copy and Paste or Fill to the rest of column A.


Regards,


Jerry

3 replies
Question marked as Best reply

Sep 1, 2011 4:48 PM in response to Community User

m,


First, add a new column "before" the existing column A. It's not possible to combine the current content of A with the current content of B and have them appear in the place of the original Column A data. So, we add a new column for the combination. If you don't want to continue to display the original First Name data hide that column.


When you combine two character strings, it's called Concatenation. There's a concatenation operator and a concatenation function. You can use either. Here are examples that meet your spec:


In the first data row of the new column A, write: =C&", "&B


Copy and Paste or Fill to the rest of column A.


Regards,


Jerry

How do I merge columns but keep the content in both?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.