Replace Strings M query

Hi han_rj,

Thanks for reaching out to the Microsoft fabric community forum.

It looks like you want to replace selected values from rows with "Header" value and you want to use MQuery so that you don't have to create multiple transformation.

Here is the MQuery to replace selected data rows from your desired data:

Here "textColumn" is the name of the column in which you want to replace data with your desired data.

If I misunderstand your needs or you still have problems on it, please feel free to let us know. 

Best Regards,

Hammad.

Community Support Team

If this post helps then please mark it as a solution, so that other members find it more quickly.

Thank you.