I'm not sure the best way to do this. I believe it is through a database.
i have raw data that has a list of Owners and the Properties they own.
I want to be able to mail one letter per owner.
This requires :
1. Separating the owners into Businesses and People
2. Formatting the Businesses and People's name into a clean format
3. Produce 4 lists
a. To Be Mailed
i. People (Duplicates Removed and Names cleaned/standardized)
ii. Businesses (Duplicates Removed and Names cleaned/standardized)
b. To Be uploaded into Podio
i People (Duplicates included and Names cleaned/standardized)
ii. Businesses (Duplicates included and Names cleaned/standardized)
The four list would be outputed into csv, google sheets.
Please provide guidelines of how you would do this at a high level.
Also, please provide an estimate of how many hours this would take.
I attached a copy of the raw data, that i want to upload into the database, have exported into clean data into the second tab format.
To ensure that I know you read the post fully, please type (Odinson) at the beginning of your reply. :)
32 freelancers are bidding on average $494 for this job
(Odinson) Dear Sir we read your task and we can deliver it with quality. please award us project so we can start working on this Best Regards! Veer Singh