Select the section to tranpose, and use "paste special" with transpose selected (or in the case of the windows 7 version click the transpose icon under paste special). Super easy.
http://www.howtogeek.com/howto/12366/convert-a-row-to-a-column-in-excel-the-easy-way/
