u/AnybodyMaleficent940

I am working on updating Squad Members for each team in the World Cup 2026.

I am importing the information from an API Football, and I have edited the headings for each, but the information has been delivered horizontally (?) as opposed to the normal vertical setup I am used to.

I have enclosed a link to a temporary file I am using to figure this out.

What I have done:

• imported the first six teams (out of 48) into the layout Squadsraw. The raw info is presented horizontally.
• In the layout Squads used =transposed() function to list vertically each of the squads,

What I would like to do:

• combine all of the info under ONE header from the downlaods/ raw data:
  • such as shown in **Layout 1 (**this was done manually this time)
• eventually have a dropdown menu of the teams, and each teams info for the squads be listed below the requested team (see Team Squads layout)

The rules for the WC Roster selections are listed in layout Rules for WC

link to file:

Roster Trial

Any help would be appreciated!