Excel Data Deduplication and Merging

I need help deduplicating and merging 5000 rows in an Excel spreadsheet.

Requirements:
- Identify duplicates using full name
- Merge data from duplicate rows
- Apply merging to all columns

Ideal Skills and Experience:
- Proficiency in Excel
- Experience with data manipulation and merging
- Attention to detail
- Ability to handle large datasets