Merge method To merge different data with the same name in the EXCEL table, you can use a pivot table.

1. Open the document in Excel.

2. After opening the document in Excel, click to insert a pivot table.

3. Click to insert data transparency to merge.