Layout change
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.
|