User Community
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: 
  • Due to the recently reported Microsoft outage, users may be temporarily unable to access My JMP or experience a delay receiving their verification codes. If you have previously installed JMP on your computer, this outage should not impact your ability to access the software. My JMP services will be restored as soon as Microsoft resolves this issue.
  • Image to Table JMP extension imports single or batch images as data tables. Useful to extract curves from pictures or convert image data to curve data to use in analyses like Functional Data Explorer. Download and install the extension.

Discussions

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

Multiple data columns into 1 row

Jan 7, 2024 10:36 PM (2828 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

Data in 1 row to 1 column.xlsx
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 (2824 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 (2824 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 (2812 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.

Recommended Articles