changing columns into rows

[Jeff]

I'm a novice using Excel 2007 in W 7.
I have an existing database where I would like to change things so that
the rows become columns and vice versa. Is there a way to automatically
do that or do I need to recreate the spreadsheet from scratch?

Thanks, Jeff

 

[Gord Dibben]

Depends upon the layout but have a look at Transpose in Help.

You may be able to simply copy and paste special>transpose.


Gord Dibben MS Excel MVP

 

[Jeff]

I have done this a few times, but not recently. As I recall, I was
able to use the Transpose option of Paste Special.

I just tried a little test case. I created a 2x3 table:

A B C
1 1 2 3
2 4 5 6

I then selected the block (A1:C2) and used copy (Ctrl-C).

I then placed the cursor on another cell, say E1 and used Paste
Special (Alt-Ctrl-V). When the Paste Special options panel popped up,
I selected Transpose in the lower right (Alt-E) and pressed Enter. The
result is:

E F
1 1 4
2 2 5
3 3 6

Is that what you need?

I'm using Excel 2007.

Thank you both. I will explore transpose.

Jeff