cancel
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
nickicmc5
Level I

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 I

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

Thank you! Worked perfectly.