You can also try to create grouping column
Col Cumulative Sum(1, :Test ID, :Sample Type)
![jthi_0-1669361444208.png jthi_0-1669361444208.png](https://community.jmp.com/t5/image/serverpage/image-id/47612i2554739A15E5A7C4/image-size/medium?v=v2&px=400)
Use that with Split
![jthi_1-1669361476446.png jthi_1-1669361476446.png](https://community.jmp.com/t5/image/serverpage/image-id/47613i87BB66E7EDC42F54/image-size/medium?v=v2&px=400)
![jthi_2-1669361485726.png jthi_2-1669361485726.png](https://community.jmp.com/t5/image/serverpage/image-id/47614i883A3153C4E7CD5F/image-size/medium?v=v2&px=400)
And then select one row from control colum and fill with previous value
![jthi_3-1669361523548.png jthi_3-1669361523548.png](https://community.jmp.com/t5/image/serverpage/image-id/47615i4AA6A04C535953B4/image-size/medium?v=v2&px=400)
and cleanup (remove order column, re-order columns, rename if needed)
![jthi_4-1669361565167.png jthi_4-1669361565167.png](https://community.jmp.com/t5/image/serverpage/image-id/47616iD081096B834EFDBB/image-size/medium?v=v2&px=400)
This works in this fairly simple case, but it is also fairly easy to loose data when using JMP's split platform so be careful with (order column tries to prevent this).
-Jarmo