Excel Tips & Tricks: Convert Horizontal Data to Vertical & Vice Versa

Category: , , , , , By Aiman Shaharuddin
Just something that I discovered today, while helping out a friend. How can I convert horizontal data into vertical? After googling in the internet, I got the answer:

1> Highlight and copy the desired data (horizontal or vertical)
2> Left click the desired location to copy the data to.
3> Right click >> Paste special
4> Check on the Transpose and OK

And, voila!! your data is transposed.. ^_^
 

27 comments so far.

  1. wikipedaia 10:10 PM
    haha.. u just discovered this? wow.. 1st time aku lg hebat dr kau. muahaha
  2. Anonymous 1:05 PM
    Hey, thanks a lot man. I didn't know about this and I needed to transpose some data for a stat class, and I had spent so much time trying to figure it out.

    Your post helped me a lot!
  3. Anonymous 10:02 AM
    Thank you very much.
    You made my day
  4. Anonymous 5:16 PM
    U r a star..thanks a lot
  5. Unknown 10:17 PM
    u r a super "star" :D thanks a lottt!
  6. Anonymous 3:06 AM
    Hello there,

    This is a inquiry for the webmaster/admin here at psyntium.blogspot.com.

    Can I use part of the information from your post above if I give a backlink back to this website?

    Thanks,
    John
  7. Yes. Feel free to do so. ^_^
  8. Anonymous 12:11 AM
    THANK U VERY MUCH SIR-SRK

    YOUR POST SAVED ME A LOT OF TIME...THAKS ONCE AGAIN.
  9. Anonymous 2:19 PM
    Thank You you just saved me having to do 40 sets of data manuall!
  10. Anonymous 8:47 PM
    Brian Urlacher youth Jersey axiotakix
    Patrick Willis Jersey axiotakix
    Larry Fitzgerald Jersey axiotakix
    http://www.authenticniketexansjerseys.com
  11. Anonymous 2:30 AM
    Thank you!! That saved me a ton of time!!
  12. Anonymous 10:06 PM
    Appreciation to my father who shared with me
    about this web site, this web site is truly awesome.

    my site basistarif gesetzliche krankenversicherung
  13. Anonymous 11:19 PM
    Hi, i think that i saw you visited my weblog so i
    came to “return the favor”.I am trying to find things to improve my web site!

    I suppose its ok to use some of your ideas!!

    Feel free to surf to my web page :: hosting web
  14. Anonymous 11:21 PM
    you're really a excellent webmaster. The web site loading pace is incredible. It kind of feels that you are doing any unique trick. In addition, The contents are masterpiece. you've performed
    a great job on this subject!

    Also visit my site Vergleichsrechner Krankenversicherung
  15. Anonymous 11:54 PM
    all the time i used to read smaller articles which as well clear their motive, and
    that is also happening with this article which I
    am reading at this time.

    My web page; Reseller hosting services
    Also see my web site - web space
  16. Anonymous 12:10 AM
    WOW just what I was searching for. Came here by searching for private krankenversicherung angebote

    my page :: Die Gesetzlichen Krankenkassen
  17. Anonymous 1:57 AM
    I feel this is one of the such a lot significant info for
    me. And i am glad studying your article. But wanna
    observation on some normal things, The site style is ideal, the articles is truly excellent :
    D. Excellent process, cheers

    my web site - berechnung private krankenversicherung
    My website > private krankenversicherung rentner
  18. Anonymous 9:01 AM
    Does your site have a contact page? I'm having trouble locating it but, I'd like to
    send you an e-mail. I've got some ideas for your blog you might be interested in hearing. Either way, great blog and I look forward to seeing it improve over time.

    Also visit my website ... bad credit loan rate
  19. Anonymous 3:50 PM
    It's genuinely very complex in this full of activity life to listen news on Television, thus I just use world wide web for that purpose, and take the most up-to-date news.

    my page :: good small Business ideas
  20. Anonymous 6:06 AM
    Way cool! Some very valid points! I appreciate you penning
    this article plus the rest of the website is also really good.



    Feel free to surf to my homepage :: krankenkasse im vergleich
    my web site: krankenkassen tarifvergleich
  21. Anonymous 10:29 AM
    I really like what you guys tend to be up too. Such clever work and coverage!
    Keep up the superb works guys I've added you guys to our blogroll.

    my web site: bad credit home lender mortgage
  22. Anonymous 11:19 AM
    This is my first time pay a visit at here and i am actually happy
    to read all at one place.

    Feel free to surf to my web blog: managed hosting
  23. Anonymous 12:29 PM
    I believe everything posted made a bunch of sense.
    But, think about this, suppose you added a little information?
    I ain't suggesting your information isn't solid, however suppose
    you added something that grabbed people's attention? I mean "Excel Tips & Tricks: Convert Horizontal Data to Vertical & Vice Versa" is a little plain. You should look at Yahoo's front page and note how they create article titles to grab viewers
    interested. You might add a video or a pic or two to get people interested
    about everything've written. Just my opinion, it might bring your posts a little bit more interesting.

    My blog; online business opportunity
  24. Anonymous 2:43 AM
    Hello There. I found your blog using msn. This is an extremely
    well written article. I'll be sure to bookmark it and come back to read more of your useful info. Thanks for the post. I'll certainly return.


    Feel free to visit my web-site - biggest affiliate programs
  25. Anonymous 5:18 PM
    Many thanks for this. You Just saved my JOB now. Cheers!
  26. Anonymous 4:55 AM
    thanx a lot for your valuable help..
  27. Anonymous 12:56 PM
    You made my job easy
    heartfelt thanks

Something to say?

<< Newer Post Older Post >>