hi, I have a set of data as displayed below
A B
1 apple 8.1
2 orange 9.5
3 orange 10.3
4 apple 11.2
5 orange 90.5
6 apple 73.8


and I would like my end results to be
A B
1 apple 8.1
2 apple 11.2
3 apple 73.8
4 orange 9.5
5 orange 10.3
6 orange 90.5

please help! thank you very much!