Loop through columns in Find Replace Tool

[TinaZhao]

I have a dataset that contains several columns of keywords that I wish to do keyword search on. Is there a way to loop through those keyword columns in "Find Value" of Find Replace tool and append each column? Attached the sample dataset below. I think about doing an iterative macro but idk how to update the find value in the tool.

[Qiu · Accepted solution]

@TinaZhao 
If I understand your intetion correctly, we will need a mapping file for find and Relace first then we can use the combination of "Transpose" and "Cross Tab" to dynamiclly handle multiple columns.