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.

The index values still identify the original 12 orders, but there’s more than one row for order 1, 4, and 5, which indicates those orders have multiple items. You can put your hoop away–no ...