Sometimes we need to re-arrange (sort) the columns rather than rows of our data in Excel. For instance, we may need to see the Customer ID column in a 10-column table as the first column followed by his Order ID because we are more concerned with this piece of detail in our current analysis task.
That said, a lot of us are not aware that we can sort columns the same way we sort rows in Excel. You just need to insert a new row with numbers of each column sort order. Then, with the Sort wizard, switch the sort options to “Sort left to right”.
Watch the video for the steps.
