Using JMP • Reshape Data • Transpose Rows and Columns
Previous
 • 
Next
Transpose Rows and Columns
You can create a new JMP table that is a transposed version of the active data table. The columns of the active table are the rows of the new table, and its rows are the new table’s columns.
When you transpose columns, you do the following:
•
Select the columns to be transposed.
•
Specify a “label” column, from which the new columns get their names (optional).
•
Specify “by” columns, which tells JMP to transpose data within groups (optional).
Note: Columns that you want to transpose must have the same data type. Also, if columns contain value labels, transposing uses the actual data values, not the value labels. (See Value Labels in The Column Info Window.)
To transpose rows and columns
1.
Open a data table that contains the rows and columns that you want to transpose.
2.
Select Tables > Transpose.
Transpose Window
3.
Highlight the column name(s) you want to transpose in the Select Columns box on the left.
4.
Click Transpose Columns.
5.
(Optional) Customize your transposed table further using the additional options. See Description of the Transpose Window.
6.
Click OK.
Description of the Transpose Window 
Select Columns Filter Menu
Contains options to search and filter through columns. See Columns Filter Menu in JMP Platforms.
Transpose selected rows only
To transpose only rows that are currently highlighted in the active table, click the box beside Transpose selected rows only.
Output table name
(Optional) To name the subset table, type a name in the box beside Output table name.
Label column name
(Applicable only if you have specified a Label column.) Specify an alternative name for the Label column. Otherwise, the default column name is Label.
Keep dialog open
To keep this window open after clicking OK, check the box beside Keep dialog open.
Transpose Columns
Adds the columns that you want to transpose.
Label
To use the data from a column in the original table as the column names in the new table:
1.
Highlight a column from the Select Columns box on the left.
2.
Click Label. The column name appears in the Label box.
The default column name is Label. You can specify an alternative name for the column using the Label column name option. Only one column is created for each distinct value in the label column. Therefore, if there are duplicate values in the label column, JMP creates only one column for the duplicated value using the value from the last duplicated row.
By
To organize the transposed columns into groups based on the columns that you put into the By box:
1.
Highlight the column name(s) in the Select Columns box whose values you want to see as a group.
2.
Click By.
Rules for Transposing describes the rules that apply to transposing.
Rules for Transposing 
If
Then
The original table has columns but no rows
The new table contains one column that lists those column names.
The original table has one column and it is assigned to Label
Its values become the column names in the transposed table.
The original table has multiple columns and contains a label column
JMP automatically inserts the label column into the Label box when the window appears. You can remove this column if you do not want it to appear.
There is no label column in the original table
The column names in the transposed table are Row 1, Row 2, …, Row n where n is the number of rows in the original table.
Examples of Transposing Rows and Columns
This section contains three examples: a simple example of transposing, an example using the Label option, and an example using a By group.
Simple Example of Transposing
1.
Open the Materials1.jmp sample data table.
2.
Select Tables > Transpose.
3.
Select plastic, tin, and gold and click Transpose Columns.
4.
Click OK.
Simple Transposed Table
The original table in Simple Transposed Table has two rows and three continuous columns called plastic, tin, and gold. The transposed table has a row for each of the three columns in the original table, and columns named Row 1 and Row 2 for the original table’s rows. The additional column called Label has the column names (plastic, tin, and gold) from the original table as values.
Example Using the Label Option
1.
Open the Materials2.jmp sample data table.
2.
Select Tables > Transpose.
3.
Select plastic, tin, and gold and click Transpose Columns.
4.
Select item and click Label.
5.
Click OK.
Transpose with a Label
The values from the item column in the original table are used as column labels in the transposed table.
Example Using a By Group
1.
Open the Animals Subset.jmp sample data table.
2.
Select Tables > Transpose.
3.
Select subject and miles and click Transpose Columns.
4.
Select season and click Label.
5.
Select species and click By.
6.
Click OK.
Transpose Using a By Group
The transposed table contains values that have been transposed in groups.