Hi guys,
In the pic below I've created four tables. Fruit1/2/3. I want to create all the unique combinations possible from these. After using Power Query with this formula = Table.ExpandTableColumn(#"Added Custom1", "FruitMerge2", {"Fruit3"}, {"Fruit3"}) I get the fourth table which you can see in columns FGH.
The first problem is I only want unique combinations, the first of which only appears in Row14 - i.e. only one fruit type per row, no duplicates. Nevertheless, even with this situation I thought I could simply use Remove Duplicates in Data tab, selecting all three columns. However it only seems to work for two columns not 3! When I include all three it removes no rows. I also tried Advanced Sort in Data and no change. Any help much appreciated!
In the
In the pic below I've created four tables. Fruit1/2/3. I want to create all the unique combinations possible from these. After using Power Query with this formula = Table.ExpandTableColumn(#"Added Custom1", "FruitMerge2", {"Fruit3"}, {"Fruit3"}) I get the fourth table which you can see in columns FGH.
The first problem is I only want unique combinations, the first of which only appears in Row14 - i.e. only one fruit type per row, no duplicates. Nevertheless, even with this situation I thought I could simply use Remove Duplicates in Data tab, selecting all three columns. However it only seems to work for two columns not 3! When I include all three it removes no rows. I also tried Advanced Sort in Data and no change. Any help much appreciated!
In the