Trick 019 Replace data in table by one-column condition

In the process of working with Excel sometimes we also need to replace some data in a cell with other data. This is easily done with the Replace command in Excel.

   But the problem is that we have to bulk replace the data in the spreadsheet according to the condition of an original cell or column. This is difficult to do with the simple Replace function in Excel.

 In Excel, there is an additional Power Query application. With the power and convenience of Power Query, replacing data according to this condition is made easy.