I found out something new from one of my webinar attendees recently. You can sort sideways in Excel.
I was under the assumption that you couldn’t sort by columns, that you could only sort by rows. Well, there is an option in the Sort dialog that allows you to sort by columns.
My table below has a few issues in terms of getting the dates sorted out in the columns.
If I select the range B1:F5 and right click it, I can choose Sort and then Custom Sort.
In the Sort dialog the Options button opens the Sort Options dialog and allows you to change how you sort.
Once selected, you can choose the row to sort by, rather than the normal column selection.