Comments on: How to flip data in Excel: reverse columns vertically and rows horizontally

Comments page 2. Total comments: 46

1. 

   Charlene says:
   2020-12-15 at 8:22 pm

   I have 2 tables of data for example:
   8 16 37 50 62
   13 22 44 53 64
   5 17 36 46 75
   3 28 42 47 71

   in one table and:
   7 26 35 57 66
   2 24 37 59 63
   3 29 44 58 70
   14 27 43 51 64

   in the other, how can I check if the REVERSE of any numbers are in the same row? For example, how can I make sure that 62 isn't in the same row as 26?

2. 

   Gabi says:
   2020-06-12 at 10:59 am

   Hello,
   Thank you so much!
   This was very helpful!

3. 

   Simon says:
   2020-05-20 at 7:03 am

   Many, many thanks. This tutorial has saved me a lot of faffing and time. Don't think I would have worked this out without some help as the method is not what you would call intuitive. Nonetheless, it's very easy when you know how. Now I do to. Cheers.

4. 

   MevaD says:
   2020-04-30 at 2:27 pm

   Thanks

5. 

   DMarie says:
   2020-04-02 at 8:59 pm

   Excellent macro for horizontal flip - THANK YOU!

6. 

   M A Motin Sobuj says:
   2020-03-11 at 10:03 am

   Thanks a lot for this nice post

7. 

   Derek says:
   2020-02-11 at 2:14 am

   Thank you for the Index(range, Rows(range)) trick! Worked perfectly.

8. 

   Glyn Tomkins says:
   2020-02-07 at 7:33 pm

   good article - might i offer another elegant, quick way to flip the rows ie horizontal flip?

   Transpose the data (copy - paste special - transpose)
   use your method for flipping columns - i.e. the numbers and a sort

   Transpose the data back again

9. 

   juan figueroa says:
   2019-12-13 at 1:21 pm

   hello and thanks,
   have you the function version of both pls?
   thanks again!

10. 

    Ishan says:
    2019-07-27 at 2:24 pm

    Thanks.

11. 

    Edward says:
    2019-03-26 at 3:40 pm

    Thanks Roman, that was an extremely easy way to flip horizontally, took seconds.

12. 

    Roman says:
    2019-02-01 at 4:05 am

    To flip horizontally, you can also simply transpose first, then sort A-Z (if necessary add column with numbers first to use to), then transpose back. Done.

    1. 

       max says:
       2019-05-20 at 9:49 am

       excelent solution

    2. 

       Svetlana Cheusheva says:
       2019-03-22 at 10:13 am

       Hi Roman,

       Wonderful idea, thank you for sharing! Hope you won't mind that I included this method in the tutorial and included a few visuals to better convey the steps. Just one caveat: if the source data contains formulas, they may get broken during the transpose process.

13. 

    Marvan says:
    2019-01-04 at 3:14 pm

    Thank you so much. This is a life saver! I being searching for a solution like this nearly for an hour now. Thank you again!

14. 

    yuvraj bhalke says:
    2017-11-25 at 8:54 am

    we need this details

15. 

    Charly Paredes says:
    2017-08-06 at 4:20 am

    Thanks, for the article.