I maintain a table of scores weekly.
So in week one it may look like
Fred Joe Harry
10 20 5
(joe winning)
but in week two
Fred Joe Harry
30 22 45
(harry winning)
is there an easy way to automatically reorder the columns so that it would read, using the above examples, left to right winning order
Joe Fred Harry
20 10 5
Week 2
Harry Fred Joe
45 30 22
eg the top most person in the left column, next highest in the 2nd column, and so on?
This summary table pulls its data from a bigger table so there is scope to do some sort of sort to derive this table.
I've also simplified it slightly since as well as the main score there are other factors associated with each person
Fred Joe Harry
Score 30 22 45
Percent A 46 29 53
Percent B 15 2 77
Stuff 0.1 55 23
But its the score thats driving the column order I'd like to see if its possible
TIA
So in week one it may look like
Fred Joe Harry
10 20 5
(joe winning)
but in week two
Fred Joe Harry
30 22 45
(harry winning)
is there an easy way to automatically reorder the columns so that it would read, using the above examples, left to right winning order
Joe Fred Harry
20 10 5
Week 2
Harry Fred Joe
45 30 22
eg the top most person in the left column, next highest in the 2nd column, and so on?
This summary table pulls its data from a bigger table so there is scope to do some sort of sort to derive this table.
I've also simplified it slightly since as well as the main score there are other factors associated with each person
Fred Joe Harry
Score 30 22 45
Percent A 46 29 53
Percent B 15 2 77
Stuff 0.1 55 23
But its the score thats driving the column order I'd like to see if its possible
TIA