Data extraction, manipulation, subsetting
Hello everyone, I am trying to write a script that would help me look up the highest number in one column and extract the data from its adjacent column. However, the table I have looks somewhat like this: I want something like this: I hope somebody knows how to go ahead with such a problem. I have tried using transpose and Split options but they dont seem to work the best for me. Any help would be...