Forum Discussion
Excel 365 Power Query Help extracting unique data
So I have already set up a power query in a sharepoint folder to pull data from a specific sheet. I have "Column 1" and "Column 2". Each column contains a list of names. Some of the names will ap...
For me that are 2 tables with 1 column each.
And the results are 2 more tables with 1 column each.
Do a left anti join from table 1 to table 2 and a left anti join from table 2 to table 1.