From Excel Help:
Switch rows of cells to columns or columns to rows
Data from the top row of the copy area appears in the left column of
the paste area, and data from the left column appears in the top row.
1 Select the cells that you want to switch.
2 Click Copy .
3 Select the upper-left cell of the paste area.
The paste area must be outside the copy area.
4 On the Edit menu, click Paste Special.
Show me
5 Select the Transpose check box.


--
cycling-rod