Rearranging Data
I have a data set that comes in from Excel whereby several key pieces of information are arranged in individual cells. To make this data useful in JMP, I came up with a scheme to populate the data systematically in columns using lag statements. I have some consistency in the layout which allows me to use fixed lag values. I included an example for rearranging the data contained in the cell to t...