A hlookup type problem

[jakechan]

Hello! 

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

Description	Supplier 1	Supplier 2	Supplier 3	Supplier 4	Supplier 5	Minimum Value	Supplier of Minimum Value
Item 1	26.45	21.16				$21.16	Supplier 2
Item 2			8.33	12.76	20.49	$8.33	Supplier 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 solution]

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

[T_Willins]

Hi @jakechan,

You were on the right track transposing the data.  Based on the data you provided I think this should work.