Hi,

This link may help

http://www.techonthenet.com/excel/fo.../transpose.php

or

Select the cells to transpose, Edit | Copy
Right-click on the upper-lefthand corner of a range of empty cells that can accommodate the transposed result.
Choose Paste Special and check the transpose checkbox

VBA Noob