To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY formula. Alternatively, to extract, filter, and sort columns from a dataset ...

Sorting data enables you to categorize your data and arrange it in a particular order. For example, if you are sorting data on houses for sale, you can sort the data by a particular value, such as by ...

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.