I have a database in excel where there are duplicated text items in col A.
In Col B are text items (names). I want to create a "table" that in Col A of
the table will have only one accurance of the items in Database col A, and in
the adjacent column (or columns) will have the items from the Database Col B.
I've tried pivot tables but I couldn't find a way to have text displayed in
the data section. I've tried functions but couldn't find something that
worked with multiple occurances.

Database: Table:
col a col b col a col b (and/or
Col c, d etc)
blue Joe Blue Joe
green Ed Green Ed Bob
green BoB Orange Ralph
orange Ralph Red Ed Mary Sam
red Ed
red Mary
red Sam