Press "Enter" to skip to content

Case-Insensitive Power Query Merges

Ed Hansberry takes us through a pain point in Power Query:

Power Query is notorious for being case sensitive. Even its language is case sensitive. Often though you get data from users where they are using different cases for the same data. Some never use the shift key, and others CAPSLAP everything.

Click through for your two options, plus a bonus option which might work.