Hi, you can do this as follows:
1) From the main menu, select Cols > New Columns... and add N columns by typing that number into the Number of Columns to add box. If you like, add them as a group and type something into the Column Prefix box.
![brady_brady_0-1677724839400.png brady_brady_0-1677724839400.png](https://community.jmp.com/t5/image/serverpage/image-id/50598i1BFB3C6B79C0A292/image-size/medium?v=v2&px=400)
2) Highlight all the new columns, right-click in the column header area and select "Standardize Attributes"
![brady_brady_1-1677724999170.png brady_brady_1-1677724999170.png](https://community.jmp.com/t5/image/serverpage/image-id/50599i1B2EA70A1C5B0AA3/image-size/medium?v=v2&px=400)
3) Under Column Properties, use the drop-down to select Formula:
![brady_brady_2-1677725017367.png brady_brady_2-1677725017367.png](https://community.jmp.com/t5/image/serverpage/image-id/50600iF410E35D919D1FF4/image-size/medium?v=v2&px=400)
4) Select "substitute column reference" and then click Edit Formula:
![brady_brady_3-1677725084550.png brady_brady_3-1677725084550.png](https://community.jmp.com/t5/image/serverpage/image-id/50601i18D0014B757FB159/image-size/medium?v=v2&px=400)
5) Enter the first formula and click OK:
![brady_brady_4-1677725126997.png brady_brady_4-1677725126997.png](https://community.jmp.com/t5/image/serverpage/image-id/50602i9A6D60469E455494/image-size/medium?v=v2&px=400)
6) Uncheck the reference column checkbox. The input should look like below. Then press OK.
![brady_brady_5-1677725202237.png brady_brady_5-1677725202237.png](https://community.jmp.com/t5/image/serverpage/image-id/50603i2BC54A0206DA5490/image-size/medium?v=v2&px=400)
7) The results show formulas as desired:
![brady_brady_6-1677725233201.png brady_brady_6-1677725233201.png](https://community.jmp.com/t5/image/serverpage/image-id/50604i1CEA0D8459B70A00/image-size/medium?v=v2&px=400)
Cheers,
Brady