How Do I Combine Multiple Columns Into One Column in Excel 2010

Microsoft Excel 2010 spreadsheets provide a great way for you to separate related data so that you can sort and edit some information without affecting other information.

But you may find yourself in a situation where data that you had originally separated into different columns is more useful to you when it is combined into one column.

You may have attempted to resolve this problem by individually copying and pasting data between individual cells, but that can be very tedious.

Luckily you can combine multiple columns into one column in Excel 2010 using a specific formula. You can even choose to separate the data with a word or character.

The formula that we discuss below is very versatile and can solve a lot of problems. Read this guide on how to combine 3 columns in Excel for more information.

How to Combine Columns in Excel 2010

Note that this is a little different than the Merge feature that you might have used in other situations.

This method will not actually change the structure of the cells, it simply affects the data contained within the cells that you are choosing to combine.

If you have not used the Merge feature before, you can check out this article to see if that is a better choice for your situation.

Step 1: Open your Excel 2010 file that contains the columns of data that you want to combine.

Step 2: Identify the columns of data that you want to combine. For example, I want to combine columns A and B in the image below.

identify excel columns to combine

Step 3: Click inside an empty column where you want the combined data to be displayed.

Step 4: Type =CONCATENATE(XX, YY) into the first cell where you want to display combined column data. In the example below, I am combining data from cells A2 and B2.

how do i combine multiple columns into one column in excel 2010

Step 5: Click the cell you just created, then press Ctrl + C to copy it.

Step 6: Select the rest of the column below the cell you just created, then press Ctrl + V to paste the copied data into these cells.

paste formula into the rest of the cells

If you want to insert something between the combined cell data, such as a “-“, then you can modify the formula so that it looks like this –


This formula actually has a lot of different uses, so experiment with it to see what it can do to benefit your usage of Excel.

Are you looking to upgrade to Microsoft Windows 8? Click this link to learn more about Windows 8 and check for the lowest price and best options for completing the upgrade when it becomes available.

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy