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

SORT: Rearranges rows or columns based on a selected column, either in ascending or descending order. SORTBY: Adds versatility by allowing you to sort data based on values in a separate range ...

To sort data in Google Sheets, you first need to freeze headers that don't need to be sorted. To freeze a header row, highlight the row, open the View menu in the toolbar, and select Freeze cells.