To remove the duplicate rows in Excel:
In Excel 2007, Excel 2010 and Excel 2013 there is a button called Remove Duplicates on the Data Menu ribbon.
1. Open your file in Excel.
2. Click on the Data Menu item.
3. Select the entire spreadsheet.
4. Click the Remove Duplicates item ( near the middle of the ribbon).
5. Select just the columns that contain the fields you want to de-dupe (e.g. Profile Name or idcode) and click OK.
The records remaining will be de-duped on the value(s) chosen. You can then remove or hide columns that relate to the details of the records leaving just those you need.