Reshape Data | JMP 12

JMP Support 800.450.0135 (US)

Documentation Feedback
Your feedback is important to us. us any comments about our documentation.

Using JMP • 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

•	anonymize the data

Creating a Subset Data Table from a Report

Contents

Create a Subset Data Table

Stratified Subsets

Create a Subset Data Table from a Report

Sort Data Tables

Example of Stacking into One Column

Example of Stacking into More than One Column

Examples of Splitting Columns

Transpose Rows and Columns

Examples of Transposing Rows and Columns

Concatenate Data Tables

Example of Concatenating Data Tables

Example of Concatenating Data Tables and Table Variables

Join Data Tables

Examples of Joining Data Tables

Update Data Tables

Example of Updating a Data Table