[h=4] Combine Rows With Same ID/Name By VBA[/h]
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.
Hope above information will help you. If you want to get more information about excel then you should go for advance excel training course.