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
Solved! Go to Solution.
Thank you so much @AkimasaKajitani
Finally got it!!!
@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.