Sorry for the cryptic title:
Basically I have a list as shown in "INPUT" below and I want to have it automatically convert into the "OUTPUT" below.
It basically separates out the ID#s under their respective team names.
The way I thought I could accomplish it would be to have it...