Ill demonstrate few handy ways to merge columns in excel row-by-row into one.

We will be merging the First Name and Last Name to single column Full Name.

We will rename this column as per requirement, in our case it is Full Name.

For example CONCATENATE(B4,,C4,, E4) which will result as Brijesh Sharma B.

If you remove the obsolete columns ( First Name or Last Name ), then the data in the merged column ( Full Name column in our case) will be lost.

This operation will just convert the formula to the actual value set.

However, the previous method is used to merge any columns, no matter if there is any space or column in between.

Merging columns using notepad requires both the merging columns to be placed adjacent to each other.

Alternatively, you can Press Tab and then hit CTRLSHIFTLeftArrow and then CTRLX to copy a Tab character as well.

This method seems tedious, but you will literally fall in love with the beauty of this method once you try it.

By using Excel Flash Fill ( Enable it if you havent already ), you can easily merge multiple columns in excel.

This can also be considered as shortcut for merging cells in excel in some lay-man terms.

By this time, you will see that Excel has understood what you intend to do and will suggest you an auto-fill.

Hit Enter and your data from both the merging columns will be merged into one column.

Needless to say, you still have one more method to merge columns in excel and this time well make use of third-party plugin.

I recommend Kutools for Excel which has various features to ease up your work and optimise productivity.

You will be able to merge multiple cells in excel without losing data.

Never share your personal information in the comments section.

Here you will find the latest updates on trending tech news, unbiased product reviews, and how-to guides on various gadgets.

Excel For Mac How To Consolidate Data