Hello all!

I am new to this forum and appreciate any help you guys can give me.

I have some data with the following format.

DISTANCE #
1 75
1 3
2 2
2 32

0.5 22
1 17
1 8
2 3
2 2

0.5 3
0.5 27
0.5 39
1 34
2 1

I need a column that will add distances of the same number. For example I need a column that says 78 35 22 25 5 68 34 1

Is there any way I can do this? I have tried some if statements with limited success.

Thanks for in advance for any help you can offer.

Van