How to merge columns without losing data in Excel

Many customers have reported that whereas making an attempt to merge and mix columns in Microsoft Excel, they lose data aside from that in the left-most column. To counter this drawback, you need to use some system. We will present you the best way in this submit.

Combine columns without losing data in Excel

You can Merge and mix columns without losing data in Excel utilizing the next two strategies:

  1. Using an Operator
  2. Using the CONCATENATE system.

Let us see each these strategies in element.

1] Using Operator

You can merge and mix columns without losing data in Excel utilizing an operator. The syntax for a similar could be:

=&&&...

While utilizing this system, please be sure that the primary cells with the textual content for every column are in the identical row. Also, in case any cell is clean in any of the cells in the columns, it could be skipped whereas merging.

Eg. Assume that you just want to merge three columns of textual content. The columns are column A, B, and C. In all of the three columns, the primary row with the textual content is row three (it’s important for the primary texts in every column to be in the identical row). Also, allow us to assume the texts in the columns are until row 7.

Then the system for merging shall be:

=A3&B3&C3

how to merge columns without losing data in excel - How to merge columns without losing data in Excel

Enter this system in row three of the column in which you want the merged textual content. Eg, for those who want the merged textual content in column E, place the system in cell E3. Hit Enter to get the merged textual content of cells A3, B3, and C3 in cell E3.

Click anyplace exterior cell E3 after which again on cell E3 to spotlight the Fill choice. Then drag the system throughout the column to cell E7. This will assist in displaying the merged textual content of all of the columns in column E.

However, the difficulty is that the merged textual content would haven’t any areas between the preliminary texts. If you want to add areas, modify the system, and make it as follows:

=A3&" "&B3&" "&C3

1568527516 388 how to merge columns without losing data in excel - How to merge columns without losing data in Excel

Enter this system in cell E3 and use the Fill choice to prolong it throughout the column.

2] Using the CONCATENATE system

For utilizing the CONCATENATE system for this situation, the syntax could be:

=CONCATENATE(:)

Eg. In the above-mentioned instance, the system would turn out to be =CONCATENATE(A3:C3)

1568527516 567 how to merge columns without losing data in excel - How to merge columns without losing data in Excel

In this case, A3:C3 would signify the vary of the columns. The CONCATENATE system is very useful whenever you want to would with a lot of columns, and mentioning them individually isn’t doable.

Hope this helped.

Leave a Comment