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

Excel tables use named columns, allowing for flexible column placement and easy reference. Arrays, on the other hand, reference ranges by position, making them less adaptable when columns need to ...