Need to check and replace a part of the values in Power Query

[Santhosh_V]

Hi All,

I would like to check all the rows in the table and replace a part of the values in each and every row with defined values. Below is an example, On row 2, I would like to replace the product category with Foods, Transportation, Lending.

@v-yueyunzh-msft , @FreemanZ @Padycosmos , Any help on this if possible?

Thanks in advance!!

[Santhosh_V]

Thanks, @Ahmedx 

[Ahmedx · Accepted solution]

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

https://1drv.ms/u/s!AiUZ0Ws7G26Rhn5DuxNsX0zECb_a?e=GlPGDn
this is a required step:

[Ahmedx]

Is this what you are looking for?

[Santhosh_V]

Hi @Ahmedx,

Yes, Correct. Thanks!