How to combine rows with same ID/name in Excel?

Combining rows with the same ID or name in Excel is a common task for organizing and summarizing data. Whether you're consolidating sales records, summarizing survey results, or organizing datasets, the process can be streamlined using Excel's built-in tools. Here's a detailed guide to help you efficiently combine rows with the same ID or name.
Combine rows with same ID/name by VBA
This method will introduce a VBA to quickly combine all rows with the same ID or name in the specified selection. Please do as follows:
1. Press "Alt + F11" keys to open the Microsoft Visual Basic for Applications window.
2. Click "Insert" > "Module", and then paste the VBA code into the Module window.
VBA: Combine Rows with the Same ID/name in Excel
Sub Consolidate_Rows()
Dim xRg As Range
Dim xRows As Long
Dim I As Long, J As Long, K As Long
On Error Resume Next
Set xRg = Application.InputBox("Select Range:", "Kutools For Excel", Selection.Address, , , , , 8)
Set xRg = Range(Intersect(xRg, ActiveSheet.UsedRange).Address)
If xRg Is Nothing Then Exit Sub
xRows = xRg.Rows.Count
For I = xRows To 2 Step -1
For J = 1 To I - 1
If xRg(I, 1).Value = xRg(J, 1).Value And J <> I Then
For K = 2 To xRg.Columns.Count
If xRg(J, K).Value <> "" Then
If xRg(I, K).Value = "" Then
xRg(I, K) = xRg(J, K).Value
Else
xRg(I, K) = xRg(I, K).Value & "," & xRg(J, K).Value
End If
End If
Next
xRg(J, 1).EntireRow.Delete
I = I - 1
J = J - 1
End If
Next
Next
ActiveSheet.UsedRange.Columns.AutoFit
End Sub
3. Press the F5 key or click the Run button to run this VBA.
4. In the popping out Kutools for Excel dialog box, please select the rows you will combine, and click the OK button. See screenshot:
Now you will see the rows in the specified range are combined with commas by the same ID. See screenshot:
Combine rows with same ID/name by Kutools for Excel
Don’t worry if you’re not familiar with VBA coding—Kutools for Excel offers an "Advanced Combine Rows" feature that simplifies the process. With no complicated operations needed, just a few clicks are enough to quickly merge rows with the same ID or name. This powerful tool also supports column merging, summing, counting, averaging, and more, making it the perfect solution for all your diverse data processing needs.
1. Select the data range you will combine, and click "Kutools" > "Merge & Split" > "Advanced Combine Rows". See screenshot:
2. In the "Advanced Combine Rows" dialog box, please specify the following operations:
- Select the ID or name column you will combine other data based on, then select "Primary Key" from the "Operation" drop down;
- Next, select other column name, and click the drop down list from the "Operation" field, and choose one delimiter from the "Combine" section. Repeat this step for other columns you want to combine ;
- Click OK button.Tip: If you need to keep the cell formatting when merging, please check "Use formatted values" option.
Now you will see the selected rows are combined based on the order ID. See screenshot:
Kutools for Excel - Supercharge Excel with over 300 essential tools. Enjoy permanently free AI features! Get It Now
By following these methods, you can easily combine rows with the same ID or name in Excel, saving time and ensuring accuracy. Choose the approach that best fits your data and objectives! If you're interested in exploring more Excel tips and tricks, our website offers thousands of tutorials to help you master Excel.
Related articles:
How to concatenate keeping number/date formatting in Excel?
How to concatenate cells from another sheet/different sheets in Excel?
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
All Kutools add-ins. One installer
Kutools for Office suite bundles add-ins for Excel, Word, Outlook & PowerPoint plus Office Tab Pro, which is ideal for teams working across Office apps.





- All-in-one suite — Excel, Word, Outlook & PowerPoint add-ins + Office Tab Pro
- One installer, one license — set up in minutes (MSI-ready)
- Works better together — streamlined productivity across Office apps
- 30-day full-featured trial — no registration, no credit card
- Best value — save vs buying individual add-in