Converting Item Binary classification to it's Source name

[MAAbdullahAlMubarah]

Dear Experts 

I have a table for the customer (names) and columns each column represent Item name bought by the customer, The value inside each Item column is binary (0/1) means bought or not bought by the customer.

I need to create a new column (Item Class) that displays the Item name instead of the binary value for each customer, the image below may translate the Idea correctly.

Note: I don't want to use formula tool (if-then-else) because I have around (45) Item.

[Thableaus]

Hi @MAAbdullahAlMubarah 

What about a transpose tool (grouping by Rec No and Customer), followed by a Filter Tool with "Value = 1"?

Then Select Tool to rename Item Column and drop Value column.

Cheers, 

[Thableaus · Accepted solution]

@MAAbdullahAlMubarah 

WF attached.

Cheers,