This project involves completing data for business locations. The current data consists of several fields including (1) business name (2) partial address (street name and number). I require (1) business name to remain the same and completion of (2) *full address (street number, street name, city, state, zip code) (3) *latitude (4) *longitude. When I type the partial address in Google, it displays the correct full address. I need someone to automate this process and auto populate a worksheet. Please note the source does not have to be Google, it just needs to be accurate. The other requirement is the corresponding latitude and longitude.
This is to be completed for approximately 500 records. See the attached sample.