• JMP 12 Online Documentation (English)
    • Discovering JMP
    • Using JMP
    • Basic Analysis
    • Essential Graphing
    • Profilers
    • Design of Experiments Guide
    • Fitting Linear Models
    • Specialized Models
    • Multivariate Methods
    • Quality and Process Methods
    • Reliability and Survival Methods
    • Consumer Research
    • Scripting Guide
    • JSL Syntax Reference
    • JMP iPad Help
    • JMP Interactive HTML
  • Capabilities Index
  • JMP 13.2 Online Documentation

JMP Support 800.450.0135 (US)

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

Using JMP • Reshape Data
Previous
 • 
Next
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
Stack Columns
Example of Stacking into One Column
Example of Stacking into More than One Column
Split Columns
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
Anonymize Data