Comparer.OrdinalIgnoreCase

Replacing values is a common transformation for cleaning data. Power Query allows you to easily replace values using the user interface. Yet, this is often …

Read moreReplace Values in Power Query – Ultimate Guide