Create a series if new columns

[#1]

I have a table with column F1 to F10 which contains temperature in Fahrenheit, I would like to create another sets column C1 to C10 in Celsius within the same table. How can I do that?

[#2]

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

Stacked data with some cleanup (Recode columns to remove F from Label and new C column to perform calculations)

jthi_1-1692868586233.png

Split final data

jthi_2-1692868621580.png