Forum Discussion
Extract unique values from multiple columns
Hello BI21 ,
like for example you could in power query, duplicate the table you have then remove all columns except the one you want to extract the values from then right click on this column and choose remove duplicates.
so you'll have every unique value in this column.
If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos 👍
Thank you for your hint! However, this only works when I apply it to one of the columns, not to several columns. So when I mark the first two columns of the example data and apply "Remove duplicates", it only removes the last row because the entry "D (in column 1) B (in column2)" is indeed a duplicate but the result is still a table. I want as answer only "A, B, C, D"