As an enhancement to Excel’s calculation engine, the Dynamic Arrays functionality enables a single formula to produce results that expand into other cells, as demonstrated in the SORT example below.

Another way to split data into multiple columns is to use some of Microsoft Excel's functions. If you choose this route, remember that the split values will be linked to the original values, meaning ...

SORT()’s array argument is the entire FILTER() function. The sort_index value of 2 sorts by the Value column, the second column in array. The sort_index value is -1, which applies a descending sort.

Sorting is one of Microsoft Excel's easiest tasks. Click; you're done! At least until you need to sort by multiple columns. For this sort task, you'll need a custom sort. Here's how.

If you regularly work with data sets in Excel, you know how important it is to be able to quickly find the information you need.

For example, if you want to sort an employee list by column headings "Hire Date," "Last Name" and "First Name," in that order, then the first column you select should be "Hire Date." ...

To sort by multiple fields (called sorting keys), repeat steps 3 and 4, then click the Add Level button and choose another field (under Column) from the drop-down list in the Then By field. Select ...