HLook or VLook Function

[bengaluru]

Hello friends

This must be very simple and probably stupid. But I need a function that can sort the following rows.




Currencies
USD CAD DHM EURO

John $10.00
Mark $24.00
susan $360.00
John $120.00
Mark $2,000.00
Susan $300.00
John $10.00
mark $90.00
susan $241.00
John $316.00
Mark $311.00
Susan $420.00





What I am looking to do is bring all currencies that John owes in one horizontal column and similarly for Mark and susan so that I will end up with only three rows. I am not good at Hlook or VLook which I guess is probably the function to use.

Any help is highly appreciated.

Thanks