Navigation: Reference > Transforms >
Sorts rows by 1 or more columns.
•Click the '+' button to add a new sort level.
•Click the 'x' button to delete the selected sort level(s).
•Click the up arrow to move the selected sort level(s) up.
•Click the down arrow to move the selected sort level(s) down.
•Set Column to the column you want to sort by.
•Set Order depending on whether you want to sort this column Ascending to Descending.
•If you add multiple levels, it will sort by level 1 then level 1 values that are the same will be sorted by level 2 etc.
•Number, date and text values are treated differently for comparison purposes.
•Any values that can be converted to numbers will be treated as numbers.
•Any values that match the supported date formats in Preferences will be treated as dates.