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


Using JMP > Reshape Your Data > Transpose Rows and Columns in a Data Table > Examples of Transposing Rows and Columns in a Data Table
Publication date: 06/21/2023

Examples of Transposing Rows and Columns in a Data Table

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. Select Help > Sample Data Folder and open Materials1.jmp.

2. Select Tables > Transpose.

3. Select plastic, tin, and gold and click Transpose Columns.

4. Click OK.

Figure 6.14 Simple Transposed Table 

Simple Transposed Table

The original table in Figure 6.14 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. Select Help > Sample Data Folder and open Materials2.jmp.

2. Select Tables > Transpose.

3. Select plastic, tin, and gold and click Transpose Columns.

4. Select item and click Label.

5. Click OK.

Figure 6.15 Transpose with a Label 

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. Select Help > Sample Data Folder and open Animals Subset.jmp.

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.

Figure 6.16 Transpose Using a By Group 

Transpose Using a By Group

The transposed table contains values that have been transposed in groups.

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