How to replace fields of multiple columns in a single stretch

[Gsiva3]

Hi Team,

I have around 80 columns in my input 1 named as AA, BB, CC, DD, etc., And I have column1 & column2 in input 2 file. What I need is I want to replace the fields of all the 80 columns in input 1 with the values from column2 in input2 file.

I know this could be done with Find & replace tool. But with Find & replace tool, I was only able to replace values in one column, not able to replace values in all the 80 columns.

I have attached the input & output files for your reference.

Please do the needful. 

[Emil_Kos]

Hi,

Cross tab and transpose tool are very handy in a situation like this: