Forum Discussion
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. 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
basilwhite Perhaps the Merge sheet (output from PQ) is what you had in mind. See attached.
4 Replies
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!!
