In this article we will show you how to merge rows in Google Sheets in just a few simple steps.
The rows must be adjacent. You should cover only the portions with data.
The merged rows look like this:
No, they have to be adjacent.
Yes, just make sure they are adjacent with each other.
No, because this method only retains the data from the first row.
If you want to combine the data, check out our article about how to merge cells and keep data in Google Sheets.
Here are the steps:
For this example, they are rows 1 and 2, covering 5 columns from Column A to E. We plan to merge A1 with A2, B1 with B2, and so on. This will result with the values stored along a single row, which is what we want.
The CONCAT function can be used to combine the data from two cells of different rows but along the same column. Its syntax is
=CONCAT(cell1,cell2)
Where cell1 and cell2 contain the data. If you want to combine three or more of them, use the CONCATENATE function:
=CONCATENATE(cell1,cell2,cell3,...)
Where cell1, cell2, and cell3 contain the data. For our example, we want to combine the data in Row 1 and Row 2 along the same column using the CONCAT function. The resulting formula for column A is
=CONCAT(A1,A2)
The same pattern is followed for the other columns covered by two rows.
The result of the formula is:
Apply the same formula to other columns to complete the row by drag-copying the cell to other columns.
We need to do this in order to keep the result of the CONCAT formula when we merge them in the next step. Select the row containing the formula, copy it using the keyboard shortcut (Ctrl+C in Windows and ⌘+C in Mac), select Paste special, then select Values only.
This will replace the formula with its output value.
Select the two rows to merge, then go to Format in the main menu, click Merge cells, then select Merge vertically.
A pop-up box will appear reminding you that only the top-leftmost value will be preserved. Click OK.
Result:
You can use the keyboard shortcuts in doing this:
You have to do this for each cell, else Google Sheets will break the merged rows into separate rows again.
Output:
You can clean it up by deleting the row we used to temporarily hold the data.
-Merge Row Shortcut in Google Sheets
-How to Unmerge Cells in Google Sheets
-How to Split Text to Rows in Google Sheets
Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.
.png)
