SEE: How to use Find All to manipulate specific matching values in Excel (TechRepublic) Listing A shows a macro that automates the simple two-column sort that we ran in the last section.

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

Duplicates in the same column are easy to find by sorting or filtering. Duplicates that span multiple columns require a bit of setup, but the solution's not difficult to implement.

Splitting data into multiple columns isn't the only way to rearrange data in Excel. For example, you could merge data from two columns into one column, split alternate rows into two columns, or ...

Excel has announced a new array-based function called SORT, which can be used to sort data in one or more columns without involving a manual sort process or a complicated macro process.

How to Create Graphs in Excel With Multiple Columns. Column graphs offer a visual representation of data that allows easy comparison between multiple values. Typically, these columns are uniformly ...