This should be easy for a spreadsheet guru!
1st .XLSX Spreadsheet: 14,071 rows of data, A-AM columns.
2nd .XLSX Spreadsheet: 14,058 rows of data, A-AF columns.
3RD .XLSX Spreadsheet: 4,262 rows of data, A-AF columns.
Primary Key among all files is the Sku column.
YOUR JOB==>
1. If a Sku exists in the 1st and 2nd spreadsheets, copy columns Z-AJ from 1st spreadsheet to columns AG-AQ of 2nd spreadsheet.
2. If a Sku exists in the 1st and 3rd spreadsheets, copy columns Z-AJ from 1st spreadsheet to columns AG-AQ of 3rd spreadsheet.
Additional Skus in 1st spreadsheet that do not exist in 2nd or 3rd spreadsheet should be ignored.
Data on all spreadsheets should not be altered in any way.
Also, the data is confidential so your bid means you agree not to distribute it or share it with anyone.
Thanks!
