How to fill out columns with specific number patterns
Hi!
I would need to add two new columns to my dataset:
Column 1: Have the same value for three rows then add +1, e.g:
n
n
n
n+1
n+1
n+1
Column 2: Add numbers from 1 to 3 constantly to rows, e.g.
1
2
3
1
2
3
Below is a picture of what i’m trying to achieve. I guess column expressions could do the job, but I haven’t figured this it out and any help would be much appreciated!
Thanks,
Ilkka