cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • DownloadSemiconductor Toolkit: Tools to create wafer maps, add wafer geometry to graphics, explore die defects & compare wafers.
  • Discovery Summit 2026: Early User Edition - September 23-24.Register. It's free.
  • Use JMP Clinical with CDISC-compliant data. Review studies, ID safety and efficacy signals & communicate findings with interactive graphics. Register to see how. Aug. 27, 2 pm US ET.

Discussions

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

Transforming a matrix of data to columns (with sample labels)

Hello!

 

I process a lot of data sets with a unique format. They contain a matrix of data with a corresponding "map" of their labels. I've made a simplified version here as an example. The sample labels are in the first rows, followed by the data itself.  For example, Sample 1 was measured 3 times and results are 20, 30, 40.

 

Screenshot 2024-10-29 at 1.37.30 PM.png

I want to transform this data set so that the label is in column 1 and the corresponding data is in Column 2, like so:

 

Screenshot 2024-10-29 at 1.38.35 PM.png

 

I haven't figure out how to do this with any of the "Table" functions. I was playing around with stack to get them all into one column, but I can't grab the bottom rows and bring them over to a new column. I realize I can just copy-paste at this point, but I am looking to build a workflow. 

 

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: Transforming a matrix of data to columns (with sample labels)

Transpose your data and delete the Label column

txnelson_0-1730225833817.png

Then use

     Tables=>Stack

and use a Multiple series stack to get what you want

txnelson_1-1730225944918.png

 

 

 

Jim

View solution in original post

2 REPLIES 2
txnelson
Super User

Re: Transforming a matrix of data to columns (with sample labels)

Transpose your data and delete the Label column

txnelson_0-1730225833817.png

Then use

     Tables=>Stack

and use a Multiple series stack to get what you want

txnelson_1-1730225944918.png

 

 

 

Jim
nickicmc5
Level II

Re: Transforming a matrix of data to columns (with sample labels)

Thank you! Worked perfectly.

Recommended Articles