In Excel put curser in field you want merged data to appear (C1)
In Excel go to Paste Functions.
Choose Function Category: ALL
Choose Function Name: CONCATENATE
In Text1 click on first cell of data (A1)
In Text2 click on second cell of data (B1)
OK
If you want space, in Text2 type in a space...
I have an Excel spreadsheet that I am pulling data from Tab #2 to Tab #1 only if specified with a formula saying that I want the data to appear on Tab #1.
Once the data is populated in the columns on Tab #1, I often have blank columns.
Ex:
Alabama Blank Column Alaska Blank...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.