JMP provides several ways to restructure data in a data table, such as creating a column from multiple columns, creating indicator columns, and recoding data.
• Split a Data Table Column into Multiple Columns
• Create a New Column by Text Matching
• Combine Columns in Data Tables
• Compress Selected Columns in Data Tables
• Make a Binning Formula in a Data Table Column
• Convert Labels to Codes and Codes to Labels