[Power Query] How to Extract Unique Values From Multiple Columns In Excel?

[Power Query] How to Extract Unique Values From Multiple Columns In Excel?

[JJ_TheGreat]

Great video! - But one nitpick. The name of the video should be “How to extract DISTINCT values from multiple columns in Excel”. What you were getting was a list of all values collectively, from all lists, REGARDLESS OF THE NUMBER OF TIMES the value appears in the dataset - which by definition is the number of DISTINCT values.
A list of UNIQUE values would be a list of all of the values which appear in your dataset ONCE AND ONLY ONCE.

You can even see that there is a difference between DISTINCT values and UNIQUE values by going to the “View” menu, and then selecting one of the data profiling options: “Column profile”, “Column distribution” (and there is also “Column quality” - but it doesn’t show you the number of distinct values and the number of unique values, like the other 2 options show - in addition to showing other characteristics of your data).