Sort Descending

Shell Programming and Scripting
1

HI,

i want to sort values in descending order and get the column no.s of the sorted value. my data will look like:

subject 1 2 3 4 5
bob 78 45 89 99 54

i want the score to be sorted in descending and get the corresponding subject sorted in the output. Please help me with gawk or ??

Any help is greatly appreciated!
Thanks

2

This should give the expected output:

gawk '{
  split($0,a)
  asort(a)
  for(i=NF;i>0;i--){
    printf("%s ",a)
  }
  print ""
}' file

Regards