Why can’t I merge my two queries?

I’m new to power query.

I have two seperate excel tables with overlapping and also different columns.

I’m trying to make a hybrid and add to one report the most useful columns from the second report that are unique to the second report.

I’m doing this in excel by just adding the column names on the first file and doing an xlookup against the second file.

These lookups are all tied to part numbers.

When adding both files to powerquery and then trying to merge it is asking me to do a 1:1 and pick matching columns between the two only (or so it appears) or else it wont let me.

The whole point is to add the useful unique half from the second report to the first and have my part numbers do lookups against that data. The part numbers exist in both querys.

Sorry if this does not make much sense. I’m new but this can save me tons of time and help me automate it.