Easy task
Create a new column. I called it Sequence and give it the Formula
Col Cumulative Sum(1, :ID)
It will give a sequence number for each row for each separate ID it finds
![txnelson_0-1718052245330.png txnelson_0-1718052245330.png](https://community.jmp.com/t5/image/serverpage/image-id/65079iECDE79056D49A280/image-size/medium?v=v2&px=400)
Now all that has to be done is to use the Split platform to split the data into new columns
Tables=>Split
![txnelson_1-1718052357331.png txnelson_1-1718052357331.png](https://community.jmp.com/t5/image/serverpage/image-id/65080i0CB892B47B7DD675/image-dimensions/729x359?v=v2)
Click on OK and it will create a new data table
![txnelson_2-1718052406912.png txnelson_2-1718052406912.png](https://community.jmp.com/t5/image/serverpage/image-id/65081i6383529DACFB3C40/image-size/medium?v=v2&px=400)
Jim