Run your modified query in your SQL browser to view the results. If a duplicate key is found, the query will update the existing column instead of erroring out. Advertisement ...

There are two duplicate rows, which you can easily find by sorting, but you don’t have to sort when using Power Query. How to label duplicates in Power Query We don’t want to remove the ...