Match the team numbers to pair the names

Hi Guys,

I am trying to pair the names based on their team numbers.

Currently, I have used Rand() and Rank functions to generate "random team numbers". I need to look up on value in column "Team" and then match the same team numbers to generate paired names.

e.g. Katie and John are both in Team 1, Becky and Park are also in the same Team 3 and so forth - Output in a new column should be something like "John - Isha" and "Katie- Becky"

How do I do this? Please help out! Thank you.

Value Rank Team Number Name

0.56565 34 Team 1 Katie
0.68768 43 Team3 Becky
0.656744 22 Team1 John
0.78787 17 Team8 Chris
0.3242443 19 Team3 Park
0.9986655 21 Team8 Kane

I don't know what version "12" is. If you have MS365, here is a solution (see attached). (Assumes the above values are in columns A-D

In one column:
=UNIQUE(C1:C6)

Then in the column next to it:
=TEXTJOIN(" - ",TRUE,FILTER($D$1:$D$6,$C$1:$C$6=F1))
(copy down).