Text transformations clean and normalize strings: trim spaces (trim, clean), change case, extract characters, replace values, add a prefix or suffix. They standardize the data before grouping and joins.
Example
Table.TransformColumns(Source, {{"Nom", Text.Trim}, {"Ville", Text.Upper}})