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 ...

Microsoft Excel and Google Sheets are both great ways to store your information, and both programs make it easy to sort alphabetically. We'll show you how.