Need to change column values as title of the respective column

[Gsiva3]

Hi Guys,

I have  a input with 100 column named as say for example AAAAA,BBBBB,CCCCC,DDDDD. And the contents in every column is "X". Now what my requirement is I want to copy the column title like "AAAAA" to its column value "X". I know it can be done with simple formula using formula tool. But my concern is since I have around 150 rows for which the same thing is done, is there any simple way to do this so.

Please help me on this guys

[Gsiva3]

Thank you so much @AkimasaKajitani 

Finally got it!!!

[Qiu · Accepted solution]

@Gsiva3 
I guess I am a bit late for the party, but this is my solution for you.

And hope can finally get your accept mark for my solution.