cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
Get the free JMP Student Edition for qualified students and instructors at degree granting institutions.
Choose Language Hide Translation Bar
View Original Published Thread

Multiple data columns into 1 row

Jamebo
Level I

Data converted from STDF shows 2 units looped 40x times. Overall I have 80 test instances. I want to convert data from Col2 to Col27 into a single column as saved on "sanitized" sheet

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User


Re: Multiple data columns into 1 row

Use

     Tables=>Stack

and select columns 2-27 as the Stack Columns and then click on OK

txnelson_0-1704686544525.png

I suggest you go through the Discovering JMP document available under the Help pull down menu

Jim

View solution in original post

2 REPLIES 2
txnelson
Super User


Re: Multiple data columns into 1 row

Use

     Tables=>Stack

and select columns 2-27 as the Stack Columns and then click on OK

txnelson_0-1704686544525.png

I suggest you go through the Discovering JMP document available under the Help pull down menu

Jim
Jamebo
Level I


Re: Multiple data columns into 1 row

Appreciate the help, Jim.
Thank you as well on the Discovering JMP.
I am a newbie on JMP and the file will help a lot.