Rotating horizontal cells


D

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
 
Ad

Advertisements

G

Guest

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

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Repeating cells 1
Running balance table, monthly/year grid 3
graph question - easy 7
Loss calculations 3
How to go from table to rows?? 1
Excel data "how so sort for use" 3
Delete cells 10
Problem - lookup formula 2

Top