I have a list that has two columns.. In column A is a list of containers. in
column B is a list of components.

The containers in A can have multiple components in them i.e.

Cont Comp

1 xyz
1 ABC
1 DEF
2 aaa
3 bbb
3 baa


how can I get a list of every component that appears in a given container?
Vlookup returns a component in a given box, but not EVERY component?


ideas anyone?