list contents of a vertical table's rows in columns?

[merlin777]

I have a table of football teams one column wide and of 10 rows.

I want to create a table with teams down the left hand side and along the top so effectively creating a grid of all teams playing against each other 100 cells (I know you have to blank some)

I'm using tables because teams might be added.

The rows are easy enough but is there a way to put one row at the head of each column of my grid? I could reference them individually but i need to repeat this grid many times over.

Thanks in advance....

 

[sandy666]

maybe any example what you want to achieve?

 

[merlin777]

maybe any example what you want to achieve?

just trying to work out how to post an image....

 

[sandy666]

better is link to shared excel file with source data and expected result. use google drive , one drive or any similar

but maybe something like this?

Column1	Column2	Column3	Column4	Column5	Column6	Column7	Column8	Column9	Column10	Column11
Teams	1​	2​	3​	4​	5​	6​	7​	8​	9​	10​
1​
2​
3​
4​
5​
6​
7​
8​
9​
10​

 

[merlin777]

I'll gI've google drive a try - thanks.
Yes that table is exactly it except the numbers will be team names.

 

[sandy666]

you can add labels and headers (headers are hidden now)