Merge data from 2 CSV files

Tips and tricks
#1

You may sometimes need to use two different sitemaps for complex scraping jobs, and you may need to later combine (merge) the results into one file.

Excel works great for this, and you can use either VLOOKUP or INDEX /MATCH.:
https://www.ablebits.com/office-addins-blog/2018/10/31/excel-merge-tables-matching-columns/
merge-tables-source-data

1 Like
#2

In difficult jobs, starting two projects at the same time, using this technique is the best way to avoid losing data.
Thanks for sharing