Found this in the help section of Excel 2003. Hope that it helps
Rob
Applies to
Microsoft Excel 2000 and later
Maybe you have a column of text:
Dairy
Meat
Beverages
Produce
That you want to move into a row, so that you can use the text a
column labels in a table:
Dairy Meat Beverages Produce
Or maybe you have a row of data that you want to move into a table i
which the data is organized in columns.
You know it would be tedious to move the data manually, one item at
time. But you may not know that you can use the Paste Special button t
quickly transpose a column of data to a row of data, or vice versa.
To switch a row of data to a column, or vice versa
Copy the data in one or more columns.
Right-click your first destination cell (the first cell of the firs
row into which you want to paste your data), and then click Past
Special.
In the Paste Special dialog box, select Transpose, and then click OK.
Starting with your first cell, Excel pastes the data into a row.
If you copy and paste data from more than one column, Excel places th
data from the leftmost column on top. For example, say you copy dat
from columns A and B of a worksheet, and you paste the data int
another worksheet starting at row 1. Excel places the data from colum
A in row 1, column B in row 2, and so on
