JSL - Creating a table from existing table

drblove — Wed, 09 Nov 2016 17:54:39 GMT

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.

Re: JSL - Creating a table from existing table

txnelson — Wed, 09 Nov 2016 21:12:12 GMT

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(

topic JSL - Creating a table from existing table in Discussions

JSL - Creating a table from existing table

Re: JSL - Creating a table from existing table