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?
1 Reply
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.
