Query editor question removing applied steps

[MH1]

Hi.

If I duplicate colum and I want to filter new colum to clean and replace values more easily. Can I safely remove that filter step afterwards because I have applied many steps after that.     

[PradipMCT]

HI @MH1 ,

You can remove the column but not the step.

Regards,

Pradip Microsoft Certified Trainer

Pradip's YouTube Channel

[MH1]

So is there any good idea how to clean and replace hunreds of "bad values" meaning that those replaced has no easy logic because most values are writen tekst.