To merge two columns, it is necessary that the data of both the columns should come in one column. For this, I will first insert a new column and then merge the data of both the columns in that new column, which will create one column. To make this work I have to use the "concatenate" formula. Which is shown below:
Here, to merge both the columns, I will write like this in the third column: =CONCATENATE(A1,B1), here A1 will enter the address of the cell of column "A" and B1 will enter the address of the cell of column "B".
If there is a need for blank space between the data of the two columns, then make a slight change in it, like: =CONCATENATE(A1," ",B1)
Put Comment for quarry