Merge Rows with same name but different data

Good Afternoon,   I have a long spreadsheet that was exported from an aging software.  Each customer has a different record for each form of contact.  I need to merge all several thousand of these ...