Link unique names in primary field from another table?


I have an excel sheet which has ordered list of transactions. Each transaction shows the product and the person who bought it. There are people who have multiple transactions and who have bought different items. A few questions:

  • How do I make a table which has only unique names of people in the primary field?

  • How do I make a field which would list all of the individual things that each person has bought?

  • Also if I were to click on an item that was bought is there a way that i could show the date that it was purchased, the transaction number etc?