I need data taken and modified from a .tif document and put into an excel document.
On the document there are approximately 1200 printed names, house numbers, street name, and city/boro/township. If any are not able to be read a line just move to the next line. All addresses are in Pennsylvania (US). The city/boro/township may be different from mailing city; it will need to be confirmed to ensure it is their mailing city and find a zip code. Then take the names, house number, street, mailing city and zip code and put it into an excel file. Please combine individuals in the same household to one entry.
Example: Laurie McClure, John McClure, Marvelene McClure should appear as (column 1) Laurie, John, and Marvelene, (column 2) McClure, (column 3) 115, (Column 4) Skyline Drive, Earl Township but mailing city is (column 5) New Holland, find zip code (Column 6) 17557.