Flipping data - columns to rows and visa versa

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

HollieH - 31 Mar 2008 01:54 GMT

Is there a way to "flip" my data so that the columns become rows and the rows
become columns? In other words, I have a spreadsheet that has employee data
listed for each employee vertically down the column. I can not sort vertical
data so I want to rotate it 45 degrees so that it is listed horizontally like
a normal spreadsheet would be. Is there any way to somewhat easily do this
in Excel? I have 07 at work and 03 at home. Either will work for the
project I am working on. Thanks for ANY help !

Reply to this Message

Gord Dibben - 31 Mar 2008 02:49 GMT

I think you meant 90 degrees rather than 45 degrees.

Copy>Paste Special>Transpose perhaps?

Note: with 2003 you can transpose only 256 rows to columns

Gord Dibben MS Excel MVP

>Is there a way to "flip" my data so that the columns become rows and the rows
>become columns? In other words, I have a spreadsheet that has employee data
[quoted text clipped - 3 lines]
>in Excel? I have 07 at work and 03 at home. Either will work for the
>project I am working on. Thanks for ANY help !

Reply to this Message

HollieH - 31 Mar 2008 04:07 GMT

HA! That would have been an interesting spreadsheet.

Thank you for the term "transpose" which I found in Help and am able to move
forward.

> I think you meant 90 degrees rather than 45 degrees.
>
[quoted text clipped - 11 lines]
> >in Excel? I have 07 at work and 03 at home. Either will work for the
> >project I am working on. Thanks for ANY help !

Reply to this Message