Creating a list from portal
I have 20 teams - each one has two fields.
The teammates are added to the team by a portal. So, each record has a captain and four teammates. I need to create a list of all the players from the 20 teams. No distinction between the captains and the teammates, just a list of all the players participating. The list will then be sorted alphabetically and used as a sign-in sheet so names can be crossed off when the players arrive. My final list would simply be 100 names all in one list - no teams, no captains, just a list.
Does anyone know how to create something like this?