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
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)
After hitting the enter button, C2 will look like this (Check the image below)
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.
As soon as you will drag your mouse down, this is how column C will look like.
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.
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)
Once done, you will now notice that the formula has vanished from the function bar. It should be displaying value now instead of formula.