currency data

Hi,

I have the following data set:

Co code dealer name Currency
AB Abhay INR
CD Ritu GBP
EF Abhay GBP
GH Shikha INR

I need a consolidated list of dealers with respective co codes which should tell me the currency they deal into.

Thanks

will that works for you?

Yellow cells copy side way and green cells copy both ways.
both are array formula, press Ctrl+Shift+Enter key when entering the formula