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

You can also create customized sorting lists so that Excel can sort data in the manner you require. You can delete these lists with just a few clicks of the mouse.

You can filter data in Excel based on either certain parameters in columns or over the whole sheet, and you can later unfilter the sheet.