Unable to understand how to use the Expression for Dynamic Replace

[Anzrey]

Hi,
I would like to have some help on the data I have by using Dynamic Replace to straightaway one shot replace all the data in all of the column if there's a match in data instead of using multiple Find and Replace to replace the data column by column which is the only method I know now. This method works but not that good because if in the future I need to add more column to Find and Replace stuff, it is kinda troublesome if there's too many column. Would appreciate the help and any advice about it. The data will be attached below.
This is how my workflow looks like:

Regards,
Anzrey

[Anzrey]

I forgot to change the data type for more length, here's a small update of the file

[Ben_H · Accepted solution]

Hi @Anzrey,

If you transpose the data first you can use a single Find Replace tool.

You then cross tab the data back into its original format.

See attached example.

Regards,

Ben

[Anzrey]

@Ben_H  Thank you very much for the suggestion.