Updated date:

Excel Tutorial-How to Combine Multiple Columns Into a Single Column

Neha is a software professional who specializes in ServiceNow Customization and Implementation. She likes writing tutorial articles.

Combining 2 or more column values in an Excel worksheet can be easily done using a simple mathematical formula. The process of combining is also known as concatenation.

Formula: Concatenate(Cell1, Cell2,….)

Steps:

1. Assume these are the values in the two columns that you want to combine into one.

tutorial-ms-excel-how-to-merge-columns-in-a-microsoft-excel-worksheet

2. Corresponding to the first row of values, click on the cell where you want the concatenated value to appear. Start typing the formula with =CON, a list of formulae will appear. Select the Concatenate function by double clicking on it.

tutorial-ms-excel-how-to-merge-columns-in-a-microsoft-excel-worksheet

3. Select the first cell to be concatenated by clicking on it. The cell number will automatically appear in the formula.

tutorial-ms-excel-how-to-merge-columns-in-a-microsoft-excel-worksheet

4. Type in a comma and click on the second cell to be concatenated. The cell number of the second cell will also automatically appear in the formula. You can continue this process of adding cells to be combined by typing comma & cell number for all columns. Once you are done adding the cell numbers you can close the formula using a closing brace.

tutorial-ms-excel-how-to-merge-columns-in-a-microsoft-excel-worksheet
tutorial-ms-excel-how-to-merge-columns-in-a-microsoft-excel-worksheet

5. In this case, we just have two columns to be combined. Hence, we can close the formula using a closing brace and hitting Enter. The final formula will look like this: =Concatenate(A2,B2).

tutorial-ms-excel-how-to-merge-columns-in-a-microsoft-excel-worksheet

6. Once you hit enter, the concatenated value will appear in the cell where you have typed the formula.

tutorial-ms-excel-how-to-merge-columns-in-a-microsoft-excel-worksheet

7. If you want to copy the formula, select the cell where the formula was written and hit Ctrl+C to copy the formula.

tutorial-ms-excel-how-to-merge-columns-in-a-microsoft-excel-worksheet

8. Select the cells where the formula is going to be pasted.

tutorial-ms-excel-how-to-merge-columns-in-a-microsoft-excel-worksheet

9. Hit Ctrl+V to paste the formula in the selected cells. The result will be a column with the merged values from the two columns.

tutorial-ms-excel-how-to-merge-columns-in-a-microsoft-excel-worksheet

This article is accurate and true to the best of the author’s knowledge. Content is for informational or entertainment purposes only and does not substitute for personal counsel or professional advice in business, financial, legal, or technical matters.

© 2012 Petite Hubpages Fanatic

Comments

Petite Hubpages Fanatic (author) from Hyderabad, Andhra Pradesh on December 27, 2012:

Thank you for your interest collegedad. I am glad my hub was of some use for you.

Yes, I am currently working on some more hubs on MS Excel. Meanwhile, you may want to go through one of my other hubs on Excel. Here's the link: https://turbofuture.com/computers/Tutorial-MS-Exce...

collegedad from The Upper Peninsula on December 27, 2012:

I'm excel illiterate, but would like to learn more about it. Spreadsheets and graphs are required in a lot of my papers. I have a miserable time putting them together. Would be great to have a series of hubs that explain Excel in detail. Great hub and thanks!