Excel Sheets Cleanup and Integration

I need an Excel expert to organize and combine two Excel sheets, approximately <2K rows each, containing contact information (Names, Emails, Phones, Addresses). Key Requirements: - Cleanup and organization of two Excel sheets - Incorporate an 'Address 2' column: Move apartment/suite numbers to 'Address 2' - Create copies of rows with a secondary email, using the text before '@' as the first name, while keeping other contact details consistent - Data deduplication across 20 existing columns - Sorting the data in an Alpha Numeric order by Company Name post-cleanup - Ensuring column titles remain consistent - Combine records with identical names, ensuring that the most complete information is retained. - Standardize the format of phone numbers to ensure consistency (e.g., (123) 456-7890). - Perform data integrity checks to ensure there are no corrupt entries or inconsistencies. - Ensure that the addresses follow a consistent format, including state abbreviations and ZIP codes. Please note, the 'Emails' column should never be altered. Skills and Experience Required: - Proficient in Microsoft Excel - Experience in data organization and cleaning - Attention to detail - Ability to follow specific instructions and rules Standardize all phone numbers to a consistent format. The final combined Excel file should be saved as an XLSX format. Standardize all phone numbers to the format (123) 456-7890. Merge duplicate entries by ensuring the most complete information is retained. - Create copies of rows that have a secondary email, using the text before '@' as the first name while retaining other contact details consistent with the first email. "Great, I will proceed with the current validations in place." Duplicates should be merged by retaining the most complete information available. The project needs to be completed by 02/10/2025. The final output should be delivered exclusively in XLSX format. Handle inconsistencies in contact names when merging duplicates as follows: highlighting them for further review.