Question

You import a Product table into Power Query. The Category column contains values such as "Bikes", "bikes", "BIKES", and " Bikes" (with leading spaces). A report grouping by Category shows four separate groups that should all be one. Which combination of Power Query transformations will consolidate these into a single consistent value with the least manual effort?

Accepted Answer

Apply Trim to remove surrounding spaces, then apply Capitalize Each Word (or lowercase/uppercase) to standardize casing on the Category column

Answer

Use Replace Values four times, once for each distinct spelling, mapping every variant to "Bikes"

Answer

Change the column data type to Text and enable Column Quality profiling to auto-correct the values

Answer

Remove Duplicates on the Category column so only one version of each value remains