Power Query usage

Excel's Unique Values Feature, When combining data from many users, you could come across a number of redundant values. You may find unique values from your data collection using a variety of Excel capabilities.