Need something like running sum

[vishu19aug]

Hi,

My data is something like

name value
a_00 123
a_00 134
a_01 123
a_01 143
a_00 125
a_00 134
a_02 213
a_02 123

I want the data to be transformed to -
name value occurance
a_00 123 1
a_00 134 1
a_01 123 1
a_01 143 1
a_00 125 2
a_00 134 2
a_02 213 1
a_02 123 1

Can somebody help, which stage to use?
Thanks in Advance,
Vishal

[DSguru2B]

Search is your friend
viewtopic.php?t=142985&highlight=group+number