Microsoft Excel : How to merge First Name and Last Name ( Merge 2 or more columns)

Prerequisite : Please download ASAP Utilities and Install it. 

Steps for installation  

After installing , you will be able to see ASAP Utilities as a add on . Please check the image down below.

To Merge Column Data.

Step 1 : Select Two or More Columns that needs to be merged ( By Clicking on "A" & "B"  )

Step 2 : Go to ASAP Utilities --> Columns and Rows -->  5th Option Merge Column Data 

Before :                                                                                               After :

Voila ! - the perfect way to remove empty rows, with least effort!

Don't forget to like, share and subscribe. Thank you very much.