Dynamically populate column based on row data

[Stringpark]

Say I have a data stream with a key column and a significant number of other columns all populated as "Unused".

Key	A	B	C	D	E	F	G	H	on and on it goes
Bill	Unused	Unused	Unused	Unused	Unused	Unused	Unused	Unused	Unused
Ted	Unused	Unused	Unused	Unused	Unused	Unused	Unused	Unused	Unused

Then I have a separate stream with a Key column and another column containing the name of one of the columns from the first stream.

Key	Column Name
Bill	B
Ted	E

I want to somehow manipulate the data from the first stream to show "Allocated" where the "Column Name" data in the second stream matches a column name from the first stream.

Key	A	B	C	D	E	F	G	H	I
Bill	Unused	Allocated	Unused	Unused	Unused	Unused	Unused	Unused	Unused
Ted	Unused	Unused	Unused	Unused	Allocated	Unused	Unused	Unused	Unused

I'm struggling to figure out how to do this. Can someone help?

[neilgallen · Accepted solution]

@Stringpark Thankfully this is not a most heinous solution to your most excellent problem, dude.

By using the righteous powers of alteryx we can transpose the original data and join on the column name.

The attached workflow should get you further on your most excellent adventure.

Be excellent to each other and Party on, dude.

[Stringpark]

This is excellent! Thank you @neilgallen!