The Sort command will sort the current Dataset on up to two key columns
The sort on each key may be in ascending or descending order. Where two keys are used the data are sorted on the first key, then any blocks with identical key values are sorted within themselves using the second key.
Missing values in key columns or rows are excluded from the sort and moved to the end of the selection.
If the 'Sort' command does not produce the desired effect use the Undo Sort command from the Edit menu to restore the original layout.
Specifies the Column name to sort on. Select ascending or descending to define the required order.
Where two keys are used the data are sorted on the first key, then any blocks with identical key values are sorted within themselves using the second key. Selecting <none> from the Then sort by item means a second sort will not be performed.
Opens the help system for this dialog.
Closes the dialog and leaves the Dataset unchanged.
Closes the dialog and sorts the Dataset.