To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...

This chapter shows you how to sort the data in the HOUSES table in ascending order by style and then descending order by square footage. The sorted data are stored in a temporary table called ...

Pivot tables in Google Sheets summarize smaller sets of data from a more extensive dataset and can be sorted by rows, columns, values, and filters.