Rotating horizontal cells

[Dr. Darwin]

Hello,
I am trying to use the PivotTable using Excel 2000, but I
understand this feature only works with "lists".
Now, I have many cells that have data running horizontally
(each data is in it's own cell) and in order to work the
PivotTable I would like to know how to rotate these
horizontal cells to put them in a column type of format
rather than a row format.

for example,
Year 1980 1981 1982 1983 ... (row-current format)
Rotate it to become:
Year
1980
1981
1982
1983
..
..
..


Please let me know how to rotate the cells.
Thank you

 

[Guest]

Never mind, I figured that I have to use the special paste
function and select transpose.

 

[Ken Wright]

Just in case it helps, you will find an intro to Pivot Tables here:-

http://peltiertech.com/Excel/Pivots/pivotstart.htm