Excel question: How to rotate worksheet

Factual Questions
1

Ok. This may be another Excel question with an obvious answer. Bear with me.

I have a worksheet like this:

A  B  C  D  E

1 V W X Y Z
2 L M N O P
3 F G H I J
I need to rotate the sheet so that the rows are colums and the columns are rows. Then I can import the sheet into Access, which is my ultimate goal. So I need a method of gettin to this result.

A B C
1 F L V
2 G M W
3 H N X
4 I O Y
5 J P Z

Or I need another method of importing the sheet into Access . . . Help?

2

Here’s how to get it to

A B C
1 V L F
2 W M G
3 X N H
4 Y O I
5 Z P J

which I suspect will get you where you need to go:

Select all (ctrl A) - Copy (ctrl C)
Go to a new sheet. Click in A1
Choose Edit -> Paste Special
Click Transpose, OK

3

Hint: Another name for rotating the data in excel is transposing.

It looks the the order of your data is reversing in addition to transposing but perhaps this will get you started. Copy the area you want to transpose, on the menu click edit and paste special. One of the options in my version (excel 2000 )the lower right-hand option is transpose, this will change columns to rows and rows to columns.

Good Luck!

4

d’oh

5

Thanks jsmith and Bill H.. Worked like a charm. I never ever ever would have thought to look for the function in the paste special feature, nor would I have realized that was what was meant by transpose. I owe ya.