You can sort data to arrange in:
-
Ascending order (text is A-Z, number is smallest to largest, and date is oldest to newest).
-
Descending order (text is Z-A, number is highest to lowest, and date is newest to oldest).
-
To open a query, locate one previously loaded from the Power Query Editor, select a cell in the data, and then select Query > Edit. For more information see Create, load, or edit a query in Excel.
-
Select the down arrow (
-
In the drop-down menu, select Sort Ascending or Sort Descending.
When you sort based upon multiple columns, the order or hierarchy of the sorting is based on the order that the columns were selected.
-
To open a query, locate one previously loaded from the Power Query Editor, select a cell in the data, and then select Query > Edit. For more information see Create, load, or edit a query in Excel.
-
Select the down arrow (
-
In the drop-down menu, select Sort Ascending or Sort Descending.
-
Repeat steps 2 and 3 for each subsequent column you want to use for sorting.
For example, when you sort by State then Population, the final result is a table ordered by state with the cities in each state ordered by population. Alphabetically, Arizona comes before California. Within Arizona, Phoenix has more people than Tucson. The formula lists each sort column in sort priority and the type of sort to apply to it.
