For the latest version of JMP Help, visit JMP.com/help.


Using JMP > Enter and Edit Your Data > Organize Data in Data Tables > Rearrange Columns in Data Tables
Publication date: 04/21/2023

Rearrange Columns in Data Tables

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.

Original Order

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.

Reverse Order

Reverses the order of the data table columns.

Want more information? Have questions? Get answers in the JMP User Community (community.jmp.com).