how to do the opposite of merge or combine? - MrExcel Message Board
MarcelBeug. You can merge the queries with join kind left anti. The following code works if both subsets (Subset1 and Subset2) have the same name of the key column ("Code"). Alternatively you can merge with each subset separately. let Source = Table.NestedJoin (AllRecords, {"Code"},Subset1&Subset2, {"Code"},"Subsets",JoinKind.LeftAnti ...