Group Nr, sequence in group

[jeffv]

I have a simplified table as follows:

cat1   cat2   recid

a       1        1

a       3        2

b       6        3

b       2        4

c       0        5

What I would like to get is:

cat1   cat2   recid   grpnr  seqnr

a       1        1        1        1

a       3        2        1        2

b       6        3        2        2

b       2        4        2        1

c       0        5        3        1

It seems like it would be simple but I must be missing it.   I've tried with tile tool and multirow but can't seem to get grpnr (group number) and seqnr (sequence within group).   I have reviewed the articles but am missing how either tool will get me this info.   Any insight?

Thanks,

Jeff

[binuacs · Accepted solution]

@jeffv something like this