DRAFT - Using the Multiple Series Stack option in Stack.

ryandewitt

Video Script -

 

The Multiple Series Stacck option stacks selected columns into two or more columns. You can specify the number of columns into which you want the selected columns to be stacked by entering the number into the Number of Series box. This box appears when you check the box beside Multiple series stack.

 

Select the Contiguous option if the series consists of adjacent columns. The order in which you add columns to the box on the right determines the group to which they belong.

 

Here's an example of Stacking into more than one column. Suppose that a researcher has data on blood pressure readings. In this data table we can see the readings were taken over three days: Monday, Wednesday, and Friday. Three readings were taken each day, at 8am, 12pm, and 6pm.

First let's grab this sample data table in JMP.  Select Help then Sample Data Library and open Blood Pressure.jmp.

 

Each BP (blood pressure) column is delineated according to the date and time. The BP 8M column corresponds to readings that were taken at 8am on Monday. The BP 12W column corresponds to readings that were taken on 12pm on Wednesday, and so on. The researcher wants to stack all of the blood pressure columns into three columns that correspond to each day: Monday, Wednesday, and Friday.

Select Tables then Stack.

Select all of the BP readings and click Stack Columns.

The order of the columns reflects how the columns in the series should be grouped.

Select Multiple Series Stack.

Next to Number of Series, type 3.

Because you want to stack the columns vertically, select Contiguous.

Rename the Stacked Data Column from Data to BP (for blood pressure).

Rename the Source Label Column from Label to Day.
Completed Stack Window

Click OK.

In the stacked data table, note the following:The first Day column represents Monday. The Day 2 column represents Wednesday. The Day 3 column represents Friday.

 

Thanks for watching and Enjoy Using JMP.

 

__________________________________________________

Other options from Community Members.

 

 

Option 1

1. Tables > Stack  
2. Select all columns and move them into “Stacked Columns” window.   Check “Multiple series stack”, enter 16.   Blank out “Label” in the Label box.  Click OK to get the new table.   This has the right data but need to update the column names. 
3. In original table, select first 16 columns, then in the left hand column panel, Ctrl-C to copy
4. In new table, select all 16 columns, Ctrl-V in left hand column panel to paste new names.

  

Option 2

1. Open original table
2. Select the first 16 columns
3. Tables->Subset (make sure you select the "Selected columns" option)
4. In original table, select columns 17-32
5. Edit->Copy
6. In subset table, with nothing selected, Edit->Paste
7. Repeat 4-6 for last set of 16 columns (33-48)

Doc Ref

http://www.jmp.com/support/help/13/Stack_Columns.shtml