Wednesday, December 19, 2007

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

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:

  1. haha.. u just discovered this? wow.. 1st time aku lg hebat dr kau. muahaha

    ReplyDelete
  2. Anonymous1: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!

    ReplyDelete
  3. Anonymous10:02 AM

    Thank you very much.
    You made my day

    ReplyDelete
  4. Anonymous5:16 PM

    U r a star..thanks a lot

    ReplyDelete
  5. u r a super "star" :D thanks a lottt!

    ReplyDelete
  6. Anonymous3: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

    ReplyDelete
  7. Yes. Feel free to do so. ^_^

    ReplyDelete
  8. Anonymous12:11 AM

    THANK U VERY MUCH SIR-SRK

    YOUR POST SAVED ME A LOT OF TIME...THAKS ONCE AGAIN.

    ReplyDelete
  9. Anonymous2:19 PM

    Thank You you just saved me having to do 40 sets of data manuall!

    ReplyDelete
  10. Anonymous8:47 PM

    Brian Urlacher youth Jersey axiotakix
    Patrick Willis Jersey axiotakix
    Larry Fitzgerald Jersey axiotakix
    http://www.authenticniketexansjerseys.com

    ReplyDelete
  11. Anonymous2:30 AM

    Thank you!! That saved me a ton of time!!

    ReplyDelete
  12. Anonymous10: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

    ReplyDelete
  13. Anonymous11: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

    ReplyDelete
  14. Anonymous11: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

    ReplyDelete
  15. Anonymous11: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

    ReplyDelete
  16. Anonymous12:10 AM

    WOW just what I was searching for. Came here by searching for private krankenversicherung angebote

    my page :: Die Gesetzlichen Krankenkassen

    ReplyDelete
  17. Anonymous1: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

    ReplyDelete
  18. Anonymous9: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

    ReplyDelete
  19. Anonymous3: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

    ReplyDelete
  20. Anonymous6: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

    ReplyDelete
  21. Anonymous10: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

    ReplyDelete
  22. Anonymous11: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

    ReplyDelete
  23. Anonymous12: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

    ReplyDelete
  24. Anonymous2: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

    ReplyDelete
  25. Anonymous5:18 PM

    Many thanks for this. You Just saved my JOB now. Cheers!

    ReplyDelete
  26. Anonymous4:55 AM

    thanx a lot for your valuable help..

    ReplyDelete
  27. Anonymous12:56 PM

    You made my job easy
    heartfelt thanks

    ReplyDelete