How to assign and increment an iteration count for multiple variables with unequal rows?
Hello all.Im trying to create a column which assigns an iteration number (numeric and continuous) based on column "Comment = End of Cycle" and increments it for the same SN. The number of data points for each SN is not the same. For example.for SN = "A", rows 1-9: Iteration =1, rows 10-16 Iteration =2for SN = "B", rows 17-27: Iteration =1, rows 28-36 Iteration =2 and so on... Tried a few variation...