Quite many options. There are addins (to my knowledge) which could do this, you could write a script or you could do it interactively in JMP by stacking your data, renaming columns, adding new column to calculate C and then splitting the data back.
Start data:
![jthi_0-1692868547917.png jthi_0-1692868547917.png](https://community.jmp.com/t5/image/serverpage/image-id/55981iD07D8F6177D2B540/image-size/medium?v=v2&px=400)
Stacked data with some cleanup (Recode columns to remove F from Label and new C column to perform calculations)
![jthi_1-1692868586233.png jthi_1-1692868586233.png](https://community.jmp.com/t5/image/serverpage/image-id/55982iE26107C22BFA8AA9/image-size/medium?v=v2&px=400)
Split final data
![jthi_2-1692868621580.png jthi_2-1692868621580.png](https://community.jmp.com/t5/image/serverpage/image-id/55983i5B70F258E9E8DE04/image-size/medium?v=v2&px=400)
-Jarmo