Subscribe Bookmark RSS Feed

JSL - Creating a table from existing table

drblove

Community Trekker

Joined:

Nov 2, 2016

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

Joined:

Jun 22, 2012

Solution
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
1 REPLY
txnelson

Super User

Joined:

Jun 22, 2012

Solution
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