Forum Discussion
Solved
Table 1 has Fields A and B. Table 2 has Fields B and C. I nee
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. ...
basilwhite Perhaps the Merge sheet (output from PQ) is what you had in mind. See attached.
basilwhite Perhaps the Merge sheet (output from PQ) is what you had in mind. See attached.
Riny_van_Eekelen Thanks, but this shows the result, and I need the formula to create the result 😕
basilwhite This is not done with formulas. As stated earlier, I used Power Query.
Riny_van_Eekelen Many thanks!!
