Hi,

I would have a list of data such as;

A 4
B 3
C 2
A 5
C 7
A 1

I would like to use some of index and match type function to look through
the list and output the values that correspond to A for example.

So the output would read A 4 5 1 (horizontally)
B 3
C 2 7

Any ideas on what is the best function to use. Index and match I can only
get to pick up the first entry?