Bulk Replacements (Replace Multiple Values in a Table at once) in Power Query
By Replace, we mean Replacing the complete cell content and not individual words or part of cell content, using a Transformation Table. In a way we are not doing a simple Substitute, but we are doing Find & Replace, by matching entire cell content.
We shall explore M Functions like List.ReplaceMatchingItems, TableToColumns, Table.ToRows, etc. in this video.
