Currently, Power Query identifies duplicates with the value 2 in the Find Duplicates column and displays all duplicates. However, if you scroll to the right, you can see that the Index column is ...

How to list duplicate values with Power Query. Let’s use Power Query to see values repeated in the columns. To do so, click anywhere inside the data set, click the Data tab, and then do the ...