1st | H | Result | 2nd | H | Result | 3rd | H | Result | 4th | H | Result | 5th | H | Result |
<<irrelevant>> | D | 12.09 | <<irrelevant>> | E | 12.09 | <<irrelevant>> | C | 12.10 | <<irrelevant>> | B | 12.10 | <<irrelevant>> | A | 12.12 |
<tbody>
</tbody>
So I have the above table and then I want a consecutive rank for each 'H' value.
For example, at the moment I have
A | B | C | D | E |
3 | 5 | 3 | 1 | 1 |
<tbody>
</tbody>
What I want is
A | B | C | D | E |
2 | 3 | 2 | 1 | 1 |
<tbody>
</tbody>
So far I've seen methods of doing this vertically instead of horizontally but I can't manage to adapt them.
Help would be much appreciated.