Flipping columns in Excel 3

Anerol,

I had this same problem. Here is how I solved it.

Lets say in column 'A' you have a list of data, starting in cell A1, and going through A10. What you need to do is in cell B1 type the number 1. In B2, the number 2. Effectively, you want to number your rows from top to bottom.

Now, select (highlight) both rows A and B. On the menu bar at the top, click on 'Data' and then click 'Sort'. Now select 'Column B' from the drop down list, and click on 'Descending' at the right. Click OK. The program sorts the data in column B, such the numbers start from 10 and go to 1. Your data in Column A follows.

You can also use this 'trick' if you have a ton of data points, with blank rows in between, and you want to get rid of the blank rows. Instead of numbering sequentially in column B, you number row A with a 1, and row B with a 2. Row C with a 1, row D with a 2, etc. Now sort column B with 'Ascending'...

I think you get the point...

Regards,
Grant
Aerospace Engineer

Wittenborn

That is a very clever idea.

Check out ASAP Utilities from
This is a greet FREE set of Excel add-ins. One of the many tools is "Flip Selected Cells". It accomplishes exactly what you are looking for with a single mouse click.

Everyone really should download and install a copy!