You can sort your reports based on the contents of two or more columns. When you sort, the Research Wizard rearranges the report based on the sort order you specify. You can sort reports in ascending (1 to 9, A to Z) or descending (9 to 1, Z to A) order, based on the contents of one or more columns.
To sort the report, follow these steps:
- From the Data menu, select the Organize/Sort command or click the Organize/Sort button. The Organize/Sort dialog box will be displayed.
- Select the first sorting item in the Sort by box and the sort order – ascending or descending.
- If the column you specify in the Sort by box has duplicate items, you can sort the values further by specifying another column in the first Then By box. If there are duplicate items in the second column, you can specify a third column to sort by in the second Then By box. (The Research Wizard allows for sort on up to four items).
- Click OK.