# Excel question: How to rotate worksheet **URL:** \ **Category:** Factual Questions\ **Created:** [May 24, 2004, 3:54pm UTC](https://boards.straightdope.com/t/excel-question-how-to-rotate-worksheet/246809 "2004-05-24T15:54:54Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Gfactor](https://avatars.discourse-cdn.com/v4/letter/g/9de053/32.png) [@Gfactor](https://boards.straightdope.com/u/Gfactor)\ **Post date:** [May 24, 2004, 3:54pm UTC](https://boards.straightdope.com/t/excel-question-how-to-rotate-worksheet/246809/1 "2004-05-24T15:54:54Z")
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? ---
**Author:** ![Bill\_H](https://avatars.discourse-cdn.com/v4/letter/b/a5b964/32.png) [@Bill\_H](https://boards.straightdope.com/u/Bill_H)\ **Post date:** [May 24, 2004, 4:08pm UTC](https://boards.straightdope.com/t/excel-question-how-to-rotate-worksheet/246809/2 "2004-05-24T16:08:47Z")
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 ---
**Author:** ![jsmith](https://avatars.discourse-cdn.com/v4/letter/j/df705f/32.png) [@jsmith](https://boards.straightdope.com/u/jsmith)\ **Post date:** [May 24, 2004, 4:10pm UTC](https://boards.straightdope.com/t/excel-question-how-to-rotate-worksheet/246809/3 "2004-05-24T16:10:43Z")
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! ---
**Author:** ![jsmith](https://avatars.discourse-cdn.com/v4/letter/j/df705f/32.png) [@jsmith](https://boards.straightdope.com/u/jsmith)\ **Post date:** [May 24, 2004, 4:11pm UTC](https://boards.straightdope.com/t/excel-question-how-to-rotate-worksheet/246809/4 "2004-05-24T16:11:45Z")
d’oh ---
**Author:** ![Gfactor](https://avatars.discourse-cdn.com/v4/letter/g/9de053/32.png) [@Gfactor](https://boards.straightdope.com/u/Gfactor)\ **Post date:** [May 24, 2004, 4:21pm UTC](https://boards.straightdope.com/t/excel-question-how-to-rotate-worksheet/246809/5 "2004-05-24T16:21:25Z")
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.