hard20 pts · first answer countsexcelpower-querydata-cleaning

Duplicates that Power Query keeps

Excel's Remove Duplicates treats "DELHI" and "Delhi" as the same, but Power Query's Remove Duplicates keeps both. Why?

A.Power Query only removes duplicate numbersB.Power Query comparisons are case-sensitive by defaultC.Power Query keeps the first two copies of each duplicate valueD.Power Query ignores text columns when deduping

Discussion 0

Join free to post in the discussion.

Duplicates that Power Query keeps

Discussion 0

Related questions