Table 1 has Fields A and B. Table 2 has Fields B and C. I nee

[basilwhite]

I'm trying to merge two tables in an Excel file. Each table is on its own sheet. There is a many-to-many relationship between the two tables, with Field B in common. Table 1 has Field A and Field B. Table 2 has Field B and Field C. I need a unique row for every unique Field A-Field B-Field C combination.

People have sent me to...

hhttps://support.microsoft.com/en-us/office/merge-queries-power-query-fd157620-5470-4c0f-b132-7ca2616d17f9?fbclid=IwAR2GWa7T4edVq4ZUS9Ltv1phjhiS7PaRsdfsPmThDRPfopsCdLqOi1keyAI

...but I'm too stupid to follow the instructions. Please help.

Example file at basil white dot com slash TableMerge.xlsx

[#2 · Accepted solution]

@basilwhite Perhaps the Merge sheet (output from PQ) is what you had in mind. See attached.

[#3]

@Riny_van_Eekelen Many thanks!!

[#4]

@Riny_van_Eekelen Thanks, but this shows the result, and I need the formula to create the result :\

[#5]

@basilwhite This is not done with formulas. As stated earlier, I used Power Query.