Merge two column in an Excel document.

I have an excel document with a big list in two columns.

I'd like to merge data in column B into column A.

For example:

Column A          Column B
John                    Dole
Mary                   Coleman

Column A

How do I do it?

Please advise.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

flotSenior Systems EngineerCommented:

You can concatenate it on a new column, using this:

="Column A" & "ColumnB"

Tell me if it is an option for you.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Pick an unused column, let's say column C.
Assuming your actual data starts in row 2...
Put the formula =A2&B2 in C2
Drag the formula in C2 down to the end of your data.
If the data in column C looks good...
Select from C2 to the bottom of the data in column C, and do a Copy (e.g. Ctrl-C).
Select A2 and Paste Special Values.
The contents of column C should then change, but you can ignore that.
Delete the contents of column C.
Excel amusantCommented:
Here is a macro code. click on macro and the job will be done.

please find attached an example.

Sub Joincolumn()
Dim c As Long
Dim lrow
lrow = Cells(Cells.Rows.Count, "A").End(xlUp).Row
For c = 2 To lrow
Cells(c, 1) = Cells(c, 1) & Cells(c, 2)
Next c

'If you want to delete the contents of column B  then Remove "'" from below lines.


End Sub

Open in new window

HTML5 and CSS3 Fundamentals

Build a website from the ground up by first learning the fundamentals of HTML5 and CSS3, the two popular programming languages used to present content online. HTML deals with fonts, colors, graphics, and hyperlinks, while CSS describes how HTML elements are to be displayed.

You can do it as follow by using formula:

1. Enter this formula in Column D: =CONCATENATE(A2," ",B2)
2. Copy the content of D and paste it in "Column A" as value by using paste special.
Hi Yamaafg,

'1. Enter this formula in Column D: =CONCATENATE(A2," ",B2)'
The specifications provided by nav2567 do not include a space between the names, i.e.
    Column A

So, unless nav2567 made a mistake in those specifications, your solution would not give him what he wants.  He'd have to do this instead:

Besides that, your solution is basically an incomplete version of the one I provided, since the "CONCATENATE" function does basically  the same thing as the (more concise) "&" operator.
nav2567Author Commented:
Thanks, everyone.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.