Multiple Criteria with ranking

[ryan0521]

Can anyone know this one?

I have list of data in column as shown below:

Score	Number	Grade
98	16664	LR
98	15205	LR
96	23363	LR
95	11881	LR
95	18721	LR
94	18710	LR
94	20281	LR
94	15187	LR
91.5	14775	LR
91	22325	LR
91	21417	LR
86	23675	MR
85	8260	MR
85	9432	MR
85	15429	MR
85	19386	MR
85	11473	MR
83	18718	MR
82	15294	MR
81	18934	MR
80.5	18717	MR
80.5	18720	MR
80	11474	MR
80	24969	MR
75	22260	HR

<tbody>
</tbody>

And I want to make it like this:

LR MR HR Score Number Score Number Score Number 98 16664 86 23675 75 22260 98 15205 85 8260 96 23363 85 9432 95 11881 85 15429 95 18721 85 19386 94 18710 85 11473 94 20281 83 18718 94 15187 82 15294 91.5 14775 81 18934 91 22325 80.5 18717 91 21417 80.5 18720 80 11474 80 24969 <colgroup><col width="64" span="8" style="width:48pt"> </colgroup><tbody> </tbody>

<tbody>
</tbody>

Please help me.

 

[Fluff]

Will you only ever have LR, MR & HR?