How to Merge Two Rows in Excel (4 Easy Ways)

In this article, we will demonstrate the methods available in Excel to merge two consecutive rows into one single row. We’ll use the dataset below, containing 4 columns with the net profit of some products in different areas, to illustrate the methods.

We’ll merge rows to produce two different outputs: Losing Data & Keeping Data Intact.

Method 1 – Using Merge & Center Command (Loses Data)

Here, we will merge the names of the Provinces into one row using the Merge & Center feature.

Steps:

Go to the Home tab
From the Alignment group, click Merge & Center.
Click on the Merge & Center command.

A warning window will pop up.

If you explicitly know that losing the data will not hamper you, then click OK.

The merged text New York is returned.

Apply the Merge & Center command for the rest of the cells.

The output is as in the below image.

Method 2 – Using Excel Clipboard Feature (Keeps Data Intact)

Steps:

In the Home tab, in the Clipboard section, click the Arrow Icon.

The Clipboard Window will appear on the left side of the workbook.

Select the two Rows and press Ctrl+C (copy).
Select any cell, double-click on it, and Click on the available Item to Paste.

After further application of the command sequence for the rest of the rows, the outcome will be as in the below image.

Method 3 – Applying CONCATENATE Function (Keeps Data Intact)

The CONCATENATE function or Concatenation Operator is used to merge two or more rows using various delimiter types, which separate the different text values.

Steps: