changing columns into rows

  • Thread starter Thread starter Jeff
  • Start date Start date
J

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
 
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
 
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.
Click to expand...
Thank you both. I will explore transpose.

Jeff
 
Back
Top