interchange columns with rows

H

Herman

I've run out of columns so was wondering can I rotate my project such that my
rows become my columns and vice versa, I need to work on a left to right,top
to bottom direction. project is 256 columns by 220 rows and I need 280
columns by 220 rows hence the rotation and is there an easy way,
 
J

JulieD

Hi Herman

never done this for anything of the size you're talking about but can't see
why it wont work ... insert a new blank worksheet
select your data choose edit / copy
switch to the new worksheet, click in cell A1 and choose edit / paste
special - transpose.
fix up the column widths and it should now be how you want it.

Cheers
JulieD
 
Top