What merging rows actually does in Excel

Merging rows in Excel combines the content of multiple rows into a single row. Excel has no built-in "merge rows" button the way it does for cells, so the process depends on what you're trying to accomplish. If you want to combine data from two rows into one row while keeping all the information, you'll use a formula or manual entry. If you want to visually combine cells across rows (similar to merging cells horizontally), you can merge cells vertically, though this deletes content from all but the top cell.

The confusion usually comes from mixing up two different tasks: combining the actual data from two rows, and combining the appearance of cells across rows. This guide covers both, so you can choose the method that matches what your spreadsheet actually needs.

Key Takeaways

  • Excel has no single command to merge rows; you either combine data using formulas or manually reorganize your spreadsheet.
  • If you merge cells vertically using the Format menu, Excel keeps only the content from the top cell and deletes the rest.
  • To keep all data from two rows, use a formula like CONCATENATE or the ampersand (&) operator to combine text from different cells.
  • Deleting one row and moving another row's data into the first row is often faster than using formulas for straightforward reorganization.
  • Always copy your data to a new column or sheet before experimenting, so you don't lose information if something goes wrong.

Combining data from two rows into one row with a formula

If you have data spread across two rows and want to bring it together into a single row while keeping everything, use a formula. Open your spreadsheet and click on an empty cell where you want the combined result to appear. Type a formula that pulls information from both rows.

The simplest formula uses the ampersand (&) operator. If row 1 has "John" in cell A1 and row 2 has "Smith" in cell A2, and you want them combined in a new cell, type: =A1&" "&A2. This combines the two cells with a space between them. Press Enter, and the result appears in your new cell. You can modify the formula to add commas, line breaks, or other text between the values by changing what goes between the quotation marks.

For more complex combinations, use the CONCATENATE function instead. Type: =CONCATENATE(A1," ",A2). This does the same thing as the ampersand method but is easier to read if you're combining many cells at once. After you create the formula and confirm it works, you can copy it across multiple cells or down multiple rows to combine all your data at once.

Merging cells vertically to combine appearance

If you want cells in the same column to look like one large cell across two rows, you can merge them vertically. Select the two cells you want to merge by clicking the first cell, holding Shift, and clicking the second cell. Both cells should now be highlighted in blue.

Go to the Format menu at the top of the screen. Click Merge Cells (or Merge & Center if you want the text centered). Excel combines the cells into one. However, Excel keeps only the content from the top cell and deletes the content from the bottom cell. If both cells had important data, you'll lose the bottom cell's content permanently unless you undo when ready by pressing Ctrl+Z.

This method works well when one of the rows is empty, or when you're creating a header that spans multiple rows for visual organization. It does not combine the actual data — it just makes the cells look like one larger cell.

Manually reorganizing rows when merging is simpler

Sometimes the fastest way to "merge" two rows is to delete one row and move the other row's data into the first row's empty cells. This works when the two rows have different types of information that naturally fit into different columns.

For example, if row 1 has a person's first name in column A and row 2 has their last name in column A, you can click on row 2's cell, cut the content (Ctrl+X), click on an empty cell in row 1 (like column B), and paste it (Ctrl+V). Then delete row 2 entirely by right-clicking the row number and selecting Delete. This approach is faster than writing a formula and leaves you with a cleaner spreadsheet.

Before you delete anything, copy your original data to a backup sheet or column. Highlight the rows you want to keep, press Ctrl+C to copy, right-click on a new sheet tab or empty area, and paste. This way, if you make a mistake, you still have the original data to refer to.

Combining rows with different column structures

If your two rows have data in completely different columns, you may need to rearrange your spreadsheet first. For instance, row 1 might have a name in column A and an address in column B, while row 2 has a phone number in column C and an email in column D. Before you can meaningfully merge them, you need to decide which columns belong together.

Create a new section of your spreadsheet with the column structure you actually want. Use formulas or manual entry to pull the correct data from each row into the right columns. Once everything is organized the way you need it, you can delete the old rows. This takes a bit longer than a straightforward merge, but it prevents data from ending up in the wrong place.

Undoing a merge if you lose data

If you merged cells or deleted a row and realized you lost important information, press Ctrl+Z when ready. Excel's undo function will reverse the last action and restore your data. You can press Ctrl+Z multiple times to undo several actions in a row.

If you've already closed the file or performed many other actions since the merge, undo may not work. This is why copying your data to a backup location before making changes is essential. If you don't have a backup and the data is critical, check whether your file storage system (like OneDrive or Google Drive) has a version history feature that lets you recover an earlier version of the file.

Frequently Asked Questions

Can I merge two rows without losing the data from the bottom row?

Yes. Use a formula like =A1&" "&A2 to combine the content from both rows into a new cell, or manually cut and paste the bottom row's data into empty cells in the top row before deleting the bottom row. Merging cells vertically using the Format menu will delete the bottom row's content, so avoid that method if you need to keep the data.

What's the difference between merging rows and merging cells?

Merging cells combines the appearance of cells in the same row or column into one larger cell. Merging rows means combining the data or structure of two separate rows into one. Excel has a merge cells feature but no merge rows feature, so you have to use formulas or manual reorganization instead.

If I merge cells vertically, can I split them apart again and get the data back?

If you undo when ready after merging, yes. Press Ctrl+Z right away and the cells will separate and the deleted content will return. If you've already closed the file or performed other actions, the data is gone unless you have a backup or version history available.

Is there a faster way to merge rows if I have hundreds of them?

Use a formula and copy it down to all rows at once. Click the cell with your formula, copy it (Ctrl+C), select the range where you want the formula to explore, and paste (Ctrl+V). Excel will automatically adjust the cell references for each row. This is much faster than merging rows one at a time manually.

What should I do if my two rows have data in completely different columns?

Rearrange your spreadsheet so the data is in the columns where it belongs. Create a new section with the correct column structure, use formulas to pull data from the old rows into the right places, and then delete the old rows. This prevents data from ending up in the wrong column.