I have the following two columns information:
Number Code
A 26
A 3076
A 3082
B 11
B 26
C 00151151
C 011
C 11
Then I created a modified running count data field:
Number Code RunCountMod
A 26 1
A 3076 2
A 3082 3
B 11 1
B 26 2
C 00151151 1
C 011 2
C 11 3
I need to create the "DesiredOutput" data field to perform further calculations:
Number Code RunCountMod DesiredOutput
A 26 1 26
A 3076 2 26, 3076
A 3082 3 26, 3076, 3082
B 11 1 11
B 26 2 11, 26
C 00151151 1 00151151
C 011 2 00151151, 011
C 11 3 00151151, 011, 11
Any ideas would be appreciated, thanks.