If I have two columns like below. How do I set something up, so that I can
input a Team Name, lets say Team2 for example and then under that team name I
get a list of every player on that team. So for the example below I would
end up with.

Team2
b
c
e


CA CB
Team Players
Team1 a
Team2 b
Team2 c
Team3 d
Team2 e
Team1 f
Team3 g

Thank you in Advance!!