How to sort left to right in Excel (quick tip)
Imagine you are in a life sustaining planet named Pearth, in another galaxy. One day you got to work, fired up Excel (hey, what else would you use? Excel is the best data software in any galaxy 🙂 ) and started working.
You came across a dataset that need sorting, but left to right – horizontally.
Now what? Do you turn your monitor sideways?
Nope, just use left to right sort option from Custom sort. That is right my dear alien friend. You can sort data in horizontal direction too.
See this quick demo.
Sort left to right in Excel – instructions
Left to right sorting is easier than it looks. Just follow these instructions.
- Select your data. But exclude headers (ie first column)
- Now go to Home > Sort & Filter > Custom sort
- Click on “options”
- Now select “Sort left to right”, click OK.
- Now you can set sorting by row, rather than column.
- Specify row number you want to sort on and sort order.
- Click ok and your data is sorted.
Want to fix your data instead? Just transpose it
If you want to just change the shape of your data, you can quickly transpose it using one of the below techniques.
- Copy and Paste transpose: You can quickly transpose data using copy paste. Copy your data (Ctrl+C), Paste Special (CLTR+ALT+V), Transpose. See this 15 second tutorial if you have doubts.
- Transpose data with formulas: If you don’t want to copy, then you can use formulas to transpose. See this tip to transpose data with formulas.
- Transpose with Power Query: If you are getting data from a source (text file, webpage, SQL query etc.) then you can use Power Query to add tranpose as part of load process. Here is a quick introduction to Power Query.
Now that you are on an interplanetary journey, why not pick up few more quick tips for data analysis.
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
Thank you and see you around.
Leave a Reply
|« There is an Easter Egg in this Power BI report||How to fake “Key influencers chart” in Excel? »|