cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
Jamebo
Jamebo
Level I

Multiple data columns into 1 row

Jan 7, 2024 10:36 PM (1087 views)

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

Preview file
48 KB
0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User txnelson
Super User
Solution

Re: Multiple data columns into 1 row

Jan 7, 2024 11:03 PM (1083 views)  |  Posted in reply to message from Jamebo 01-07-2024

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 txnelson
Super User
Solution

Re: Multiple data columns into 1 row

Jan 7, 2024 11:03 PM (1084 views)  |  Posted in reply to message from Jamebo 01-07-2024

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
Jamebo
Level I

Re: Multiple data columns into 1 row

Jan 8, 2024 01:59 AM (1071 views)  |  Posted in reply to message from txnelson 01-07-2024

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.