0604 Horizontal Sorting (Left to Right) - Auto-realigning 100s of Columns

3 minutes
Share the link to this page
You need to purchase the class to view this lesson.
One-time Purchase
List Price:  $139.99
You save:  $40
List Price:  د.إ514.21
You save:  د.إ146.92
List Price:  A$189.27
You save:  A$54.08
List Price:  ৳11,874.45
You save:  ৳3,392.94
List Price:  CA$174.19
You save:  CA$49.77
CHF 90.63
List Price:  CHF 126.88
You save:  CHF 36.25
List Price:  kr876.09
You save:  kr250.33
List Price:  €117.79
You save:  €33.65
List Price:  £100.24
You save:  £28.64
List Price:  HK$1,087.91
You save:  HK$310.85
List Price:  ₹10,396.08
You save:  ₹2,970.52
List Price:  RM592.78
You save:  RM169.38
List Price:  ₦57,615.03
You save:  ₦16,462.61
List Price:  kr1,223.76
You save:  kr349.67
List Price:  NZ$199.75
You save:  NZ$57.07
List Price:  ₱7,023.18
You save:  ₱2,006.76
List Price:  ₨22,717.01
You save:  ₨6,491.03
List Price:  S$189.41
You save:  S$54.12
List Price:  ฿4,598.67
You save:  ฿1,314
List Price:  ₺1,183.81
You save:  ₺338.25
List Price:  B$707.83
You save:  B$202.25
List Price:  R2,037.17
You save:  R582.09
List Price:  Лв230.32
You save:  Лв65.81
List Price:  ₩160,005.91
You save:  ₩45,719.24
List Price:  ₪453.71
You save:  ₪129.64
Already have an account? Log In


Greetings, I hope you're loving the challenges that are imposing before you. Well, here comes another one from the point of view of sorting. Assume that this is a data which spans over six columns, which contains client name hypothetical names, the country in which they are based city where the offices are located, and the office building address, and certain amount which may be under processing which may be accepted, which may be rejected. Now, for any data migration purpose, if you want to change the sequence sequence of the way the column has been placed, for example, you would want that remarks should be on the last column, you cut it and you say insert cut cells. Now for a couple of columns, you can do that manually. But I've seen occasions where there are over 100 columns and they have to upload the data on a common server, maybe a government website for filing purposes.

And they have to rearrange the sequence of the columns in a desired format. I think about it amongst the hundred columns. If you were to cut Cut cells insert cut columns, and do that repetitively every month, how tedious it could be, and it would be time consuming. Why because you have to check the accuracy of the sequence. Well, here lies a solution. If you want to have the data the column placed in a desired sequence, you just give a serial number on top of it.

For example, I would want that the country should be first. Next followed by client name, third by city, fourth by location, fifth will be amount and thereafter sixth will be remarks. So just give the sequence and primarily when you download the data from a certain era, you get exported in a certain sequence column every month consistently. So once you have given the sequence of numbers, you can also use the sequence of numbers next time next month with the same data download. Once you have done that, I'll show you a trick which you could have never imagined so far. I choose the day The entire stuff, including the rule, which contains a sequence number, I go to data, I go to thought most of us would have applied sorting at some point or the other, but nobody cared to click on this button called options.

Right now I'm going to click on button options. And take a moment to read the various options underneath. It says you want to make it case sensitive. Nope, not my objective right now, what I want is sort the data from left to right. And when I do that, immediately, you notice the data has headers option goes away. And this time you have the options sorted by which row of course my row number four is the one which contains serial number.

So I sort by row number for smallest to largest. As I press OK, notice what is going to happen. look exactly, exactly my point. The point is now it is floating the same sequence that you had mentioned, although I will require some extra seconds to create formatted. And there you go. The remarks is on the last column amount, the second last, and the first one being the country.

So this is horizontal sorting. Ensure that once you've used it, if you're using the same file for different levels of sorting, let's say vertical, you go back to sort. And please change the option to sort top to bottom. Although you don't need to press OK, because you don't need to saw this. I'm going to press cancel. So there you go.

This was horizontal sorting. I hope you enjoyed it.

Sign Up


Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.