How do I standardise columns and use it to build a regression model in JMP

[#1]

There are many ways to do this, depending on how you want to standardize. If you want to use the typical standardization that is used for a designed experiment (-1 to +1 coding), then simply turn on the coding property for the X variables.