Replace Records in a Table

Question

Hello,

We are trying to use Alteryx to replace column records with the name of the record in the corresponding row column A field IF there is an X in the column. Struggling to brain storm the best tool. See attachment for pretend data set and tab with pretend results. We don't want to create an IF statement for each column. We want anywhere there is an X to pull the Data from the Corresponding row's Column A.

Thank you in advance,

Valerie

Table Example 1.xlsx

Qiu · Accepted Answer

@valeriemattas 
We can use the Transpose and Cross Tab combination for this kind of multi-column update as below

At last then use a Dynamic Rename to restore the original Field Name.
Or just a simple Multi-Field Tool.