It's not a file that I'm importing. I'm actually highlighting and copying data off a website and then pasting it into a table. The data on the website is shown as a table but when I paste it into Numbers it ends up in a vertical column.
However I don't want it vertical, I want it horizontal so I have to use the "transpose" formula "(TRANSPOSE(Table 1::A1:A272)" in another table to transpose the contents from vertical to horizontal but it is all in one row but there are twelve players on each team so all twelve players are now in one row which isn't what I want.
So below the line with TRANSPOSE(Table 1::A1:A272) I have multiple lines where
A2 is "=R$1", B2 is "=S1" and so on across until Q2 is "=AH1"
A3 is "=AI$1" through Q3 is "=AY$1"
...
A16 is "=IV1" through Q16 is "=JL1".
But that's just a list of all the players for the day. And everyday those tables are overwritten with the next days stats even if they don't play a game that day.
So what I have is ANOTHER table 3 (the second table above). Each player's stats for each day need to be copied somewhere that they won't be overwritten. So what had is Table 3 where each player has rows of cells for each of the status for that day.
At the beginning of the year, each player has one row (one day) of stats.
On day 2, if they play or not, the stats for the year of averaged out by the number of games, not the number of years and that is the stats for 2 day on each players 2nd row of stats and so forth.
And that continues with a new row added BETWEEN the END of one players LAST row and the FIRST row of the next player. And when I paste the data into this new row it has to be static so that it doesn't change. This way I have a list for each day of the whole year.
What I'm realizing is that I probably need a separate sheet for each player and each and every day (not each of every game but every day) a new row will be added to the table for each player. But even that can't be automated in Numbers because Numbers has no scripting program like REXX in OS/2 that can be used for every app.
I would compare REXX to DOS commands but REXX is really a scripting/programing language that isn't just for batch files but can be used for any application that runs in OS/2. So a spreadsheet designed for OS/2 could use REXX as a programming language like VisualBasic for Excel except that REXX doesn't TOTALLY SUCK but is something that most average users could understand and really learn and make powerful programming inside an OS/2 spreadsheet.
The only problem is that IBM no longer makes Lotus 1-2-3 for OS/2 or I would be using that. So I'm stuck with Windows (NOT going to happen) or Linux (it's just not my cup of tea) and Libre Office - isn't amazing what you can and CAN NOT do in Libre office, so I'm using Numbers which doesn't have a scripting language.
If REXX could be used as a scripting/programming language for Numbers and other apps on MacOS it could be Apple's super power because it would immediately became magnitudes more powerful than it is now.
