Need For Clean And Format 700 Rows Of Data
I need someone to help me clean and format 700 rows of location data.
Each row contains a number of addresses.
Work to be done:
1) Separate all the addresses so that 1 row contains only 1 address.
2) Separate the address information into building, address, city, province.
3) Lookup Geolocation information for each address, and input the Latitude and Longitude of each.