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...
Kailef Probably many other ways to achieve this, but the attached file contains a 'quick-and-dirty' solution that returns two separate tables. On for all unique names only in the 1st and another for unique names only in the 2nd.