Layout change
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. |
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. |
All times are GMT +1. The time now is 02:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com