REORDER COLUMNS

Category: Transform / Basic

Move one or more columns in the table to the leftmost position, to the rightmost position, or after a particular column.

• Group columns together
• Ensure a particular order of columns before exporting to a file

You can add more column movements by clicking Add rule or by dragging column headers right in the table's data grid.

Example: Move the "Location" column after the "River" column.

Source table: The longest rivers in the world

Action parameters:

Move column: Continent
to position: After column River

Result table:

• Aggregation of consecutive date ranges (Project; Module: Main; Group: Tab 1; Table: Easymorph Patient Example Data.xlsx;
  Action position: 13)
• Sort column in an export alphabetically (tab) (Project; Module: Main; Group: Reorder columns; Table: Reorder columns;
  Action position: 2)
• Duplicating rows based on a condition (Project; Module: Main; Group: Tab 1; Table: Table 1 (2); Action position: 8)

Fast ways to create the action:

• Drag and drop a column to a new location. The Reorder columns action is automatically created.
• To reorder multiple columns at once, select multiple columns and drag and drop them to their new location. The Reorder columns action is automatically created. (To select multiple columns at once: use Shift+click to select contiguous columns; use CTL+click to select noncontiguous columns.)

• Keep/Remove columns
• Modify column(s)
• Rename columns