The issue here is trying to translate Excel paradigms to Coda or other databases. It is not a good practice to have data in column headers: ‘Pteam1’, ‘Pteam2’ and ‘Pteam3’ should be values in a column.
You can have your table with a proper structure on a hidden page and still use grouping to visualize the data in the way you like.
Take a look at my examples in these posts:
Is it possible to filter columns just like rows? - Ask the Community - Coda Maker Community
New formulas for columns - Suggestion Box - Coda Maker Community
Hope this helps,
Pablo