Searching and compiling using variable data

[nhanney]

Hello - new user looking for help getting started on the below problem. Any assistance is appreciated. 

I have a data set similar to below:

and would like an output per below:

The currencies provided will be variable so they workflow would need to systematically read available currencies and create new columns accordingly. 

Again, any help at all is much appreciated. Thank you.

[Felipe_Ribeir0 · Accepted solution]

Hi @nhanney 

One way of doing this

[binuacs]

@nhanney One way of doing this

[nhanney]

Thank you for the help on this - this solution solved the problem.