Sort and reformat excel spreadsheets and remove double ups.

1. We need this job started as soon as it’s assigned and completed within 48 hours of being assigned. If you can’t do this and if you are a poor communicator, please don’t bid for the work. 2. We need to sort out the contact details contained in several databases for the USA, Australia and Canada. These are contained in 18 Excel documents. In the name of each excel document is the country it’s from. Estimated entries are USA 19,000, Australia 7000 and Canada 5000 3. We need 3 documents, one for each country. One page per document 4. Each of these documents is currently formatted differently so the information is in different columns and they are in different stages of completion. 4. We need to combine these lists into a master list. One for each of the 3 countries with all the information in matching columns. 6. The information we require is the Business name, email address, website, street address, suburb, state, postcode/zip, mailing address, phone number, contact person, contact person’s mobile phone, contact persons position, company type. Not all this information will be available for every entry, but the available information must be included. Only information for the columns above is required, others information can be ignored. 7. We want one entry per physical address or unique business, all the double up’s need to be removed. Where only email addresses are present, include them if they are not already in listed on another line. 11. For both Australia and the USA, there is an unsubscribed list which must be filtered out of the email column only. The email address should be substituted with “unsubscribed”