Most of the time we get datasets arranged in columns (with aligned headers). This is the top to bottom format that most of us are used to. And when you sort that data, you sort it from top to bottom.
But sometimes you may need to work with data that is on rows (i.e. the headers are in a column). And if you want to sort this data, you will have to sort it from left to right (sort horizontally).
In this video I show two ways to sort data in Excel from left to right:
1. Using the Built-in Left-to-Right Sort Function in Excel
2. By first copying and transposing the data, sorting it from top to bottom, then copying and transposing it again.
Although using the built-in left-to-right sorting feature is more convenient, many people prefer to transpose it because they are used to the top-to-bottom data format.
I also explain how to create custom sort criteria in Excel. For example, when you sort the data by region from left to right, you get: East, North, South, and West.
This is because the data has been sorted alphabetically.
But what if you want to sort it in the following order: East, West, North, South.
To do this, you need to create custom sort criteria that you can then use to sort the data (left to right or top to bottom).
You can learn more about sorting data in Excel here: https://trumpexcel.com/sort-excel/
#Excel #Excel Tips #Excel Tutorial
Please take the opportunity to connect and share this video with your friends and family if you find it useful.
No Comments