Data Sorting

I am looking for somebody to go through the attached Excel spreadsheet of 2518 entries remove duplicate content and sort into the various tabs on the spreadsheet. It is a list of website URLs. There are a number of URLs on the list with different extensions to them. I would like the URLs to be stripped back to their route domain name only and then sorted into the various tasks. The completed report then needs to be emailed back to me for checking. Once I am happy with the results I will release the funds from Escrow. THIS IS A SPECIFIC PROJECT THAT NEEDS TO BE DONE CORRECTLY. PLEASE TAKE A GOOD LOOK AT THE SPREADSHEET TO SEE IF YOU CAN COMPLETE THE TASK PROPERLY BEFORE BIDDING. I want this project completed within one day of the bid being accepted. If you have any questions about the project then please do not hesitate to ask.