Excel Transpose Trick

This one minute video shows you how to take a list of items in a column and copy it to a row. It is pretty simple, but when you need it this can really save you a lot of time.

Comments

  1. I am always looking for a new excel tip and this is one that I knew existed, but had no idea where it was. Having to retype or copy/paste each cell is a pain. Thanks so much! :)

  2. Geez! I was looking for this and wondering why such a function was not available/visible. Thanks for the tip!

  3. Larry Shead says:

    great tool!

  4. DaisyPatch says:

    Perfect! I’m just getting ready to put a person’s address file from a Word do into a spreadsheet, transposing into a horizontal listing of the details!

  5. Not sure why, but I doubt you want “www wearehairy com (2)” listed along with this. It also shows up under “popular searches”.

Speak Your Mind

*