Microsoft Excel: How to Merge Data of 2 or More Columns

Microsoft-Excel-How-to-Merge-Data-of-2-or-More-Columns

Microsoft Excel is a product that is developed and marketed by Microsoft. It is a spreadsheet that can be used to add, remove, edit, view data. Excel is a wonder tool for those who work on heavy data files on a daily basis. It can process the changes to the entire file within a few seconds through formulas which saves a lot of manual work and time.

There is a lot to learn about ms excel. But here in this post, I am going to cover one feature which is merging data of 2 columns into 1 using formulas.

How to Merge data of 2 columns into 1 column in MS Excel

Step 1: Open MS Office Excel spreadsheet that has data in it.

Step 2: Look for the columns you desire to merge.

For example: In below screenshot, I added data to column A and column B which I desire to merge in column C

Microsoft-Excel-How-to-Merge-Data-of-2-or-More-Columns

Step 3: Insert a blank column after columns with data that you need to use to apply the formula for merging. Like I created column C (Data 1 Data 2) in the above screenshot.

Step 4: Go to cell C2, to apply formula and type “=A2&” “&B2”. Once done hit the enter button. (Screenshot below)

Microsoft-Excel-How-to-Merge-Data-of-2-or-More-Columns

 

After hitting the enter button, C2 will look like this (Check the image below)

 

Microsoft-Excel-How-to-Merge-Data-of-2-or-More-Columns

Step 5: Apply the formula to all the cells until C8 by left-clicking once on the little square you will notice at the bottom right corner of cell and dragging it down until C8.

Microsoft-Excel-How-to-Merge-Data-of-2-or-More-Columns

 

As soon as you will drag your mouse down, this is how column C will look like.

 

Microsoft-Excel-How-to-Merge-Data-of-2-or-More-Columns

 

Bingo! All the data of column A and column B is now merged successfully separated by space in column C. 🙂

Step 6: You should be thinking, you already got the data merged in column C, what’s left now.

You may have noticed in the above screenshot that column C is displaying merged data but the function bar is still showing the formula.

Microsoft-Excel-How-to-Merge-Data-of-2-or-More-Columns

 

So, in this step, we will get rid of the formula which is essential to be able to use the data.

Step 7: To get rid of the formula, select cell C2 to C8 and copy (Ctrl + C). Then, press the right click of your mouse to see an additional drop-down menu. Now click on little clipboard icon with 123 on it to paste the values. (See the image below)

Microsoft-Excel-How-to-Merge-Data-of-2-or-More-Columns

 

Once done, you will now notice that the formula has vanished from the function bar. It should be displaying value now instead of formula.

 

Microsoft-Excel-How-to-Merge-Data-of-2-or-More-Columns

 

Related Blogs

What is the Difference Between Windows and DOS?

Windows 10: How to Delete Temp Files or Foo Files

 

Leave a Reply

avatar
  Subscribe  
Notify of