Thanks. I am a newbie to JMP. Actually my situation is a little more complicated. Each of my row has a column of data that contains varying # of data which I want to split out. Pls see below. The Classes column is one column with "a,b,f" being one character string
Name Classes 1 Jack a, b, f, 2 Bill b 3 Steve e, r, t 4 Mary a, b, c, d
Since the # of classes each person has taken are varying, what is the correct way to break the classes column out into something like below
Name Classes 1 Jack a 2 Jack b 3 Jack f 4 Bill b 5 Steve e 6 (and so on).
I suggest you export your file as tab-delimited text and then reimport (select "Open" from File menu and "Open as: Data (using preview)") using comma and spaces as field delimiters. Then you use "Stack" from the tables menu and choose to stack all columns in your imported data table except the name column (make sure "drop non-stacked columns" is un-checked).
This would result in the expanded table you wanted, except for a number of empty rows. Those can easily be deleted after sorting.
Apology for being late in thanking everyone. I ended up doing something similar to the first suggestion of using excel to break up the contents on one column and then import everything into JMP and then used stack function. I am not good at writing formulas or scripts, so good thing to learn from the more knowledgeable. Thanks again.