Using JMP 11, Second Edition, 2nd Edition

Chapter 6 

Reshape Data

Create Subsets, Sort Data, and More

This chapter covers the following tasks that you can perform on JMP data:

• create a new data table from a subset of rows and columns

• sort by any number of columns

• stack multiple columns into a single column

• split a column into two or more columns

• transpose rows and columns

• concatenate multiple tables end to end

• join two tables side by side

• update columns in a table with values from another table

Figure 6.1 Creating a Subset Data Table from a Report