XLS Spreadsheet Assistance
Budget: $10 – $30 USD
We have 2 large CSV files.
File A (1.45 GB) contains zip code coordinates with lat/long coordinates and file B (4.3 GB) contains text data and zip code coordinates.
We want file B to be populated with lat/long coordinates where postcodes match postcodes from file A.
Some columns are to be deleted from file A and the character space removed from the zip codes. An ID column ie 1,2,3,4 has to be added.
Both files then have to be split into indovidual file sizes of around 80mb.
File A (1.45 GB) contains zip code coordinates with lat/long coordinates and file B (4.3 GB) contains text data and zip code coordinates.
We want file B to be populated with lat/long coordinates where postcodes match postcodes from file A.
Some columns are to be deleted from file A and the character space removed from the zip codes. An ID column ie 1,2,3,4 has to be added.
Both files then have to be split into indovidual file sizes of around 80mb.