How to number rows of a table by group

I have a table with 2-3 rows per subject(PATID). Now, I would like to add a column which indicate if it is the first, second or third training of a patient (as shown in the figure). There must be a simple way, but I cant figure it out.

Thanks for your help

[jonas]

It should be fairly simple. You should upload some data.

Answer 1

[jonas]

Can try something like this:

PATID = [1 1 3 3 3 5 9 9 12]'
T = table(PATID)
out = varfun(@(x)1:length(x),T,'InputVariables','PATID','GroupingVariables','PATID','OutputFormat','cell')
out = [out{:}]'

Just put out in a new column.

[Thimo Marcin]

Thank you! This worked. Kind regards

[jonas]

My pleasure!