Spreadsheet data clean up

Attached spreadsheet includes a list of about 2000 U.S. cities sorted by different states. I need someone to delete duplicate names of cities, those that are in more than one county. I need to have populations added together when this is done so total population of each city is intact (you may sort the list by city name or place name to identify duplicate cities). Then code should list county names on one line with city name, as specified, if the city is located in more than one county. Next, I need someone to go through and change formats of City names as specified. The data corrections to address, etc., will be done through a separate bid after this work is complete. ## Deliverables Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform Excel 2002 software.