Flipping data - columns to rows and visa versa

H

HollieH

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 !
 
G

Gord Dibben

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
 
H

HollieH

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Flipping columns to rows 3
columns to rows flip 3
How to move data from rows to columns 6
Pivot table data layout - columns to rows 1
IS there a way to invert rows? 2
Can I rotate data in Excel table (rows to columns, and vv)? 6
Change rows into columns, 90 degree shift 3
Arrange data spanning 8 columns and 3 rows to 24 columns and 1 row 2

Top