Forum Discussion
How to join two sheets in same workbook with one common column of data - Excel 365 User
First sheet has 7 columns second sheet has 2 columns sharing one common column only, that I must join into one table for analyzing results. Don't know how to join them / compare?
If to build separately new table with jined data Power Query shall work. If to add data from one table to another most probably ant lookup function as XLOOKUP, INDEX/MATCH, etc could work. All depends on concrete data structure.