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.
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! :)
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!
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! :)
Geez! I was looking for this and wondering why such a function was not available/visible. Thanks for the tip!
great tool!
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!
Not sure why, but I doubt you want “www wearehairy com (2)” listed along with this. It also shows up under “popular searches”.