Microsoft Excel - Merge Data

Hi, I have a spreadsheet with two sheets.

The first sheet contains names, relation and quantity. The relation is a unique number which links the names of the people who belong to the same family.

I want the second sheet to automatically generate using the information from the first sheet. This is to combine the data for the names belonging to the same family.

Example,

Sheet 1 = Names & Relation & Quantity Tom King, 01, 100 Paul David, 02, 200 Sarah James, 03, 100 Alan Jones, 01, 200 Frank Smith, 01, 200 Amy Fox, 02, 300 Etc.

Sheet 2 = Names & Quantity (combined for ones where the relation is the same) Tom King / Alan Jones / Frank Smith, 500 Paul David / Amy Fox, 500 Sarah James, 100

Thank you!