cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Sign-in to the JMP Community will be unavailable intermittently Dec. 6-7 due to a system update. Thank you for your understanding!
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.
  • JMP 19 is here! Learn more about the new features.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
Jamebo
Level I

Multiple data columns into 1 row

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.

Recommended Articles