How to combine two columns in Google Sheets and Excel

Have you ever tried combining two or more columns? You can bear witness that it is not a walk-in park for new users. This practice involves numerous ways and workarounds that new users are unaware of. This article will discuss combining two columns in Google Sheets and Excel.

To combine two columns in Google Sheets

Let us discuss methods that can be used:

Using the Concatenation function

Using the Merging Tool

Each of the above is discussed below:

Using the Concatenation function

Here are the steps to follow while using this method:

1. Visit the Google account and log in using your email detail (That is, https://www.google.com/account).

2. From the Google Apps, click on the Sheets icon and select the existing Sheet.

3. Open the dataset that you want to combine its two columns.

4. Locate the third column and type the Concatenation formula. That is, type =CONCAT(.

5. Select the cell indexes of the two cells in the columns you want to combine. That is, =CONCAT(A1, B1).


6. Hit the Enter button, and the dataset in the two columns will be combined.

Using the Merging Tool

Using the Menu bar

Using the Toolbar

Using the Menu bar

Steps:

1. Highlight the columns you want to combine.

2. Locate and click on the format tab on the menu bar.

3. On the drop-down menu, hover the mouse on the merge cells button.

Using the Toolbar

Steps:

1. Highlight the columns you want to combine.

2. Then, on the Toolbar section, locate the merging icon. You can click either the icon or the drop-down button.

3. If you click the merge button, the cells will join automatically.

4. On the other side, if you click on the drop-down menu, you will be prompted to select either;

Merge All

Merge Horizontally

Merge Vertically

To combine two columns in Excel

Methods that are used:

Using the Concatenation function

Using the Merging Tool

Using the Concatenation function

Steps to follow:

1. Open the Excel application

2. Open the dataset that you want to combine its two columns.

3. Locate the third column and type the Concatenation formula. That is, type =CONCATENATE (.

4. Select the cell indexes of the two cells in the columns you want to combine. That is, =CONCATENATE (A1, B1).


5. Hit the Enter button, and the dataset in the two columns will be combined.

Using the Merging Tool

The Format cell tool.

The Merge tool

The Format cell tool

Here are the steps to follow while using this method:

1. Open the Excel application

2. Highlight the cells you want to join. Then, Right-click and select the Format cells option.

3. From the dialogue box, click on the Alignment tab.


4. Check the Merge cells button and then click the Ok button.

The Merge tool

Here are the steps to follow:

1. Open the Excel application

2. Highlight the two columns you want to combine. Click on the left mouse and move the cursor to the region you want to join.

3. Click on the Toolbar’s Home tab and the Merge button.

4. From the menu, Choose any of the merging options.


Leave a Comment