columns and rows

[Guest]

I have a workbook set up in excel but I want to re-arrange it so that the
columns become the rows and vice versa. There is already data stored in the
workbook, so I need to make sure that it is allocated to the correct
corresponding cell afterwards. Is this possible?

 

[JulieD]

Hi

the copy / paste special - transpose function will do what you want.
However, if you want to do it to large range of data i suggest you copy the
data from your workbook and then edit / paste special - transpose into a new
workboook ... as you can't use CUT with transpose.

Notes:
the numbers of columns & rows will not change - you will still be limited to
256 columns
copy / edit - paste special transpose will not remember column or row widths
so you'll have to set them up after

Cheers
JulieD