Project Description:
I have an excel list of about 780 cities in the US (includes this information ie: Riverside, Anaheim CA US)(Attached File Charter Internet). I also have another excel list with 3300 cities including state, county, city(attached file time warner residential). Lastly, I have a list of 42,000 zip codes from the US (with city, county and state information included as well) (Unfortunately this file is too large to be uploaded so please message me on freelancer to obtain). I need all the zip codes on the third list that correspond to the cities on each of the first two lists to be matched up and compiled in to two new separate excel worksheets. Please keep the the lists of cities completely separate (Do not mix Charter with time warner) and add all the corresponding zip codes, some cities will have multiple zip codes applicable. If it makes sense, it is possible to add a zip code column to the existing city lists as long as all zip codes for each city are matched correctly.
Additional Project Description:
02/05/2013 at 20:44 GMT
To clarify I would like cities and zip codes only for both lists, still keeping them independent of one another and I have attached a sample of the zip code file I have available. As seen in the file, there are multiple zip codes for the city of Birmingham so I would need each of those listed out individually for that city, not in any type of grouping (ie. 20000-20009)
Data Entry, Excel Additional Files: Offer+28573+-+Time+Warner+Residential+-+GEO+List.xlsx Offer+28572+-+Charter+Internet+-+GEO+List.xlsx zipcodespreview.xlsx
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.
