Fill in a Spreadsheet with Data

This project involves merging around 8 mailing lists from excel, into something coherent - column names are different, so need to sort them, and addresses are spread across columns that need to be cleaned - some sheets have email addresses, some are double.\'\r\n\r\n( press, hotels, clients, buyers, resorts, etc.. about 3000 - 4000 contacts - in multiple lists ) \r\n\r\nto report back on best way to sort , then sort - and then report on what people have missing information. \r\n\r\nBasically clean all of them into a format that we can easily sort, and then upload to mail chimp if needed.