In my opinion the best tool to do this is Power Query (Excel native tool), so you can work with those two tables.

https://www.excelcampus.com/wp-conte...PowerQuery.png