Data/Matrix Editor 536
Sorting a Single Column
Sorting a Single ColumnSorting a Single Column
Sorting a Single Column
Sorting All Columns Based on a “Key” Column
Sorting All Columns Based on a “Key” ColumnSorting All Columns Based on a “Key” Column
Sorting All Columns Based on a “Key” Column
Consider a database structure in which each column along the same row contains
related information (such as a student’s first name, last name, and test scores). In such a
case, sorting only a single column would destroy the relationship between the columns.
In the Data/Matrix Editor:
1. Move the cursor to any cell in the column.
2. Press:
ˆ
and select
3:Sort Column.
Numbers are sorted in ascending order.
Character strings are sorted in alphabetical
order.
C1 C1
fred
&
75
sally 82
chris
&
98
jane chris
75
&
fred
98 jane
82 sally