Get many "text items" in rows into 1 cell

[degeus75]

I have a long Excel sheet like this (see attached):
Jack - Car
Jack - Ipad
Jack - Computer
Thomas - Ipad
Thomas - Computer
etc

I want it to be (see more detail attached):
Jack: Car-Ipad-Computer
Thomas: Ipad-Comuter

 

[Fluff]

Hi & welcome to MrExcel.
How about

=TEXTJOIN("|",,FILTER(B$3:B$16,$A$3:$A$16=$A21))

 

[Atharu]

For the names

=UNIQUE(A3:A16)

For the Stuff Column

=TEXTJOIN("|",TRUE,FILTER(B3:B16,A3:A16=A19))

For the Food Column

=TEXTJOIN("|",TRUE,FILTER(C3:C16,A3:A16=A19))