Layout change


M

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.
 
Ad

Advertisements

G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top