Layout change

[mdunn]

I am preparing an excel data sheet that contains data for each month in a year.
Currently, the data for each project month runs horizontally across the page
like this:

January February March

I would like to change the data to read this way:

January
February
March

Because there is so much data, I didn't want to have to re-enter the
information, just change the layout with out using a pivot table.

Any ideas?

Thanks.

 

[Gord Dibben]

Copy>Paste Special>Transpose.

Paste area must not overlap copied area.

Note: if using Excel version earlier than 2007 you are limited to 256 rows
of transpose to columns.

Excel 2007 has 16384 columns.


Gord Dibben MS Excel MVP