Clean WhiteSpace in Power Query
The other day as I was working through a model, I once again tripped upon the fact that Power Query’s Text.Trim function doesn’t clean whitespace inside the text string, only at the ends. For those who are used to Excel’s
