Forum Discussion
Combine two tables with both unique and duplicate values
Hi all I'm trying to combine two tables with matching columns into a third table. The column "Item ID" contains ID numbers which may exist only in table 1 (222), only in table 2 (333), or in both...
Idrissshatila
Super User
Super UserHello JW_pfsc ,
yes, you can do that through Merge queries in Power Query where you select the join full outer.
check this documentation to learn how to merge both queries https://learn.microsoft.com/en-us/power-query/merge-queries-overview
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍