One of the Array Formula Gurus might be able to make a different effect.

This pivot table solution will allow a player to be listed on more than one team. I think you'll want this with fantasy sports.