Rearrange Columns

JMP Support 800.450.0135 (US)

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

Using JMP • Enter and Edit Data • Organize Data • Rearrange Columns

•

Rearrange Columns

You can rearrange or sort data table columns by their name, data type, or modeling type, or reverse the current order. To reorder columns, select Cols > Reorder Columns and select from one of the following options:

Move Selected Columns

moves the selected columns to a particular place in the data table. Specify where to place the selected columns in the Move Selected Columns window:

–

To first: moves the selected columns so that they are in the left-most position in the data table.

–

To last: moves the selected columns so that they are in the right-most position in the data table.

–

After: moves the selected columns so that they are after a column that you identify.

returns the columns to the order they were in when data table was last saved.

Reorder by Name

arranges the columns from left to right in alphabetical order by column name.

Reorder By Data Type

arranges the columns from left to right in alphabetic order by data type (expression, row state, character, numeric).

Reorder By Modeling Type

arranges the columns from left to right in alphabetic order by modeling type (none, continuous, ordinal, nominal, multiple response, unstructured text, vector). Row state columns have no modeling type, and are shown last.

reverses the order of the data table columns.

•

Help created on 7/12/2018