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. Joi Podgorny says

    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. 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!

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>