I have a data analysis task.
We need to sort out the contact details contained in several databases for the USA, Australia and Canada. These are contained in Excel documents.
There are approximately 19000 USA entries between 6 documents (7500, 11000, 28, 180, 150, 120) I think .
Each of these documents is currently formatted differently so the information is in different columns and they are in different stages of completion.
· We need to combine these lists into a master list with all the information in matching columns.
· We need to eliminate multiples of the same businesses that have the same email address.
· Create 3 pages within the document. One with all the unique listings, one that has email addresses for all listings, and one that has mailing or physical addresses for each listing.
· The Canadian lists are contained within the USA documents and need to be separated out into a Canada list document.
In Australia we have about 7000 listings over 5 documents and we need to do exactly the same with those as for the USA lists.
I also need the contacts pulled from all customers in USA and canda [login to view URL]