Formula for moving a group

[Heidi]

Event Name of Team Player First Name Player Last Name

Womens Team Jimmy's Betty B
Cindy K
Pam B
Wendy L
Dani T

Open Team Benton Mark Z
Troy T
Brian D
Brad T

 

[Bony Pony]

.... perhaps you could be a little less cryptic? What exactly are you wanting
to happen?

 

[Heidi]

I need to have all the event separated for bracketing purposes and need to
have all players names listed for each team. There are 5 different events,
open team, womens team, doubles, open singles and womens singles. The
singles entries aren't a problem, they will only be one row of information,
but the team and doubles I grouped in order to keep all the players together
within the team.