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

Microsoft's spreadsheet program can do way more than you might realize. These are the hacks and tricks you need to know.