# MS Excel...how come this ain't easy? **URL:** \ **Category:** Factual Questions\ **Created:** [May 16, 2000, 2:21am UTC](https://boards.straightdope.com/t/ms-excel-how-come-this-aint-easy/19635 "2000-05-16T02:21:53Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![SoulFrost](https://avatars.discourse-cdn.com/v4/letter/s/f07891/32.png) [@SoulFrost](https://boards.straightdope.com/u/SoulFrost)\ **Post date:** [May 16, 2000, 2:21am UTC](https://boards.straightdope.com/t/ms-excel-how-come-this-aint-easy/19635/1 "2000-05-16T02:21:53Z")
I seem to have screwed up. I have an Excel worksheet, but now I need to reformat how the data is organized. I have Row 1 which is all the “A” stuff, Row 2 with the corrosponding data for each cell in Row 1, Row 3 with all the “B” stuff, Row 4 with the corrosponding data for each cell in Row 3, and so on through “Z”. What I need to do now is to make two very long columns:   Column 1 will contain all the data that is presently stored in the odd rows, and Column 2 for all the data in the even rows. I **thought** that I could just copy the rows from my existing worksheet, then paste them as columns in my new one, but Excel doesn’t seem to want me to do that. Any ideas on how I can turn my rows into columns, without copying each of the 3200 cells individually? Thanks in advance. -David ---
**Author:** ![SoulFrost](https://avatars.discourse-cdn.com/v4/letter/s/f07891/32.png) [@SoulFrost](https://boards.straightdope.com/u/SoulFrost)\ **Post date:** [May 16, 2000, 2:44am UTC](https://boards.straightdope.com/t/ms-excel-how-come-this-aint-easy/19635/2 "2000-05-16T02:44:27Z")
Heh…figured it out. For those who may be wondering, you have to copy the cells on the first sheet, then go to the second sheet. There, choose PASTE SPECIAL, select the VALUES button, and **then** check the TRANSPOSE box…that’s the only way I’ve found, so far. -David