I need to clean up my database with approx 3,000-4,000 customers.
-Need to separate contact information from one column into two or three if needed.
-Move rows with certain missing information onto a different sheet eg, customers with no email addresses in one sheet
-Identify customers with no numbers, customers with emails.
-Clean up all contact numbers so they are in the right format to be able to be imported into any CRM
- Add suburbs and postal codes to the customers that have missing information
Copyright © 2020 | Truelancer.com