Excel Email Data Cleanup
Budget: £2 – £5 GBP
I need an Excel expert to clean my data. The task involves removing rows with empty or 'blank' email cells, eliminating duplicate email entries, and ensuring that the data is organized and accurate.
Specific requirements:
- Filter and remove rows where the email cell is empty or contains hidden characters such as non-breaking spaces.
- Identify and eliminate duplicate email entries to maintain only unique email addresses.
- Keep the original email data, along with associated company names, in a clean and organized manner post-cleanup.
Ideal skills for this job:
- Proficient in Excel.
- Experience with data cleaning and organization.
- Ability to identify and remove hidden characters and duplicates.
After the cleanup, I would like the data sorted by email address.
see example below there are 6 thousand lines like this, ill send original folder later, but see if you can do in this example. let me know briefly how you can manage to showcase your capabilities.
DONT WASTE MY TIME ONLY QUOTE IF YOU ARE SPECILSED IN THIS AND CAN DO UNDER 20 30 MIN.
Specific requirements:
- Filter and remove rows where the email cell is empty or contains hidden characters such as non-breaking spaces.
- Identify and eliminate duplicate email entries to maintain only unique email addresses.
- Keep the original email data, along with associated company names, in a clean and organized manner post-cleanup.
Ideal skills for this job:
- Proficient in Excel.
- Experience with data cleaning and organization.
- Ability to identify and remove hidden characters and duplicates.
After the cleanup, I would like the data sorted by email address.
see example below there are 6 thousand lines like this, ill send original folder later, but see if you can do in this example. let me know briefly how you can manage to showcase your capabilities.
DONT WASTE MY TIME ONLY QUOTE IF YOU ARE SPECILSED IN THIS AND CAN DO UNDER 20 30 MIN.