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.

CopyPaste SpecialTranspose.

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


On Thu, 7 Aug 2008 06:08:00 -0700, mdunn
wrote:

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.