enter image description hereI have the following dataframe as shown in the figure. I want to set the value of Column B based on the value in the column name that corresponds to Column A value. For example, Column A first row reads “Value A”, so look for Value A column and find “aaa”. Any hint on how to do this? Thank you

Expect to output the desired value as above