MS Excel...how come this ain't easy?

Factual Questions
1

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: &nbsp 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

2

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