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...