For the latest version of JMP Help, visit JMP.com/help.


Using JMP > Reshape Your Data > Transpose Rows and Columns in a Data Table
Publication date: 04/21/2023

Transpose Rows and Columns in a Data Table

You can create a new JMP data 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.)

To transpose rows and columns, follow these steps:

1. Open a data table that contains the rows and columns that you want to transpose.

2. Select Tables > Transpose.

Figure 6.13 Transpose Window 

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.

6. Click OK.

Transpose Options

Select Columns Filter Menu

Contains options to search and filter through columns. See Column Filter Menu.

Transpose selected rows only

Transposes only rows that are currently highlighted in the active table.

Output table name

(Optional) Specifies the name of the subset table.

Label column name

(Applicable only if you have specified a Label column.) Specifies an alternative name for the Label column. Otherwise, the default column name is Label.

Keep dialog open

Keeps the Transpose window open after you click OK.

Save Script to Source Table

Saves a script to the original data table that enables you to transpose the data again using the same settings.

Transpose Columns

Adds the columns that you want to transpose.

Label

Uses the data from a column in the original table as the column names in the new table. Follow these steps:

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

Organizes the transposed columns into groups based on the columns that you put into the By box. Follow these steps:

1. Highlight the column name(s) in the Select Columns box whose values you want to see as a group.

2. Click By.

Auto Refresh

Automatically refreshes the table Preview. If the Preview takes too much time to complete, you can deselect this option and click the Refresh button Image shown here. Selected by default.

Preview with Random Subset

Select this option for very large tables that can cause delays as the Preview pane is refreshed. Deselected by default.

Table 6.1 describes the rules that apply to transposing.

Table 6.1 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.

Want more information? Have questions? Get answers in the JMP User Community (community.jmp.com).