A hlookup type problem

Question

Hello!

I need some help with a hlookup - type problem. My data looks like below:

DescriptionSupplier 1Supplier 2Supplier 3Supplier 4Supplier 5Minimum ValueSupplier of Minimum ValueItem 126.4521.16   $21.16Supplier 2Item 2  8.3312.7620.49$8.33Supplier 3

I'm having difficulty creating the "Supplier of Minimum Value" column at the end in alteryx

I tried transposing the data, and doing a find/replace using the minimum value, however this does not work as there are many items and suppliers in my table, so each minimum value is not unique

Any help would be much appreciated!

TonyA · Accepted Answer

Transposing was the right idea. Take a look at the attached.