For clarification for other interested parties
ideal output should have read

test item fail rank
1 1 10.3 2
1 3 10.1 1
2 1 100 2
2 2 99 1
2 3 101 3
2 4 100 2
3 1 112 3
3 2 111 2
3 3 109 1
*****
Thanks to Mike H for his quick reply.