cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
drblove
Level III

JSL - Creating a table from existing table

Hi All,

 

So I have this issue where I would like to make a new table, out of an existing table, but want to pull values out of specific rows and add them to new columns.  My existing table looks something like this:

 

Subject    Value1    Value 2    Value 3

NC1         26.2        13.1         6.2

NC2         28.5        14.3         45.6

PC1         22.5        12.5         75.3

VC1         63.9        37.2         89.1

NC3         45.5        37.7         8.6

PC2         27.5        53.8         83.2

PC3         72.5        68.4         32.5

NC4         78.5        92.2         66.7

PC4         16.5        18.6         18.9

 

 

I want to create a new table of just the Value 1 where I have something like

 

Value     NC1    NC2    NC3    NC4

Value 1  26.2    28.5     45.5    78.5

Value 3  6.2      45.6     8.6      66.7

 

I am sure there is some easy way to do this, but my Googling today is not up to par...  any help would greatly be appreciated.

 

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: JSL - Creating a table from existing table

Use
Tables==>Split

Tables==>Transpose
Select the values of Subject you want transposed
Use Value 1 and Value 3 as Transpose Columns
And Subject as the Label column


Then delete the unwanted columns in the new data table(
Jim

View solution in original post

1 REPLY 1
txnelson
Super User

Re: JSL - Creating a table from existing table

Use
Tables==>Split

Tables==>Transpose
Select the values of Subject you want transposed
Use Value 1 and Value 3 as Transpose Columns
And Subject as the Label column


Then delete the unwanted columns in the new data table(
Jim