I am a very basic excel user. I have a sheet which contains a few
columns of data specific to a coach, followed by a few columns of data
about each player on that coach's team.

The player columns are, say, player_1_name, player_1_number,
player_1_position, player_2_name, player_2_number, player_2_position,
etc. up to 15 players.

What I need is for the the columns of player data to line up in rows
so all the player names are in the same column, all the player
numbers are in the same column, etc.

The coach columns for these additional rows can either be blank or be
repeated for each additional row.

Can this be done?

Thanks in advance...