Did you know you can sort horizontally (left to right or right to left) in excel? I didn’t until a few days ago and I wish I knew this a long time ago.
How to sort columns by the contents of a particular row:
- Select the range you wish to sort
- Click the Data tab > Sort & Filter section > Sort
- Click Options
- Under Orientation choose Sort left to right
This allowed me to sort a set of columns by their name in the first row, and then sort by the total of that column again later to show the highest totals together.