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.

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

Move column: Continent
to position: After column River

• 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