One way:-

http://j-walk.com/ss/excel/usertips/tip068.htm


--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"Trip Levert" wrote in message
...
Each month I get hourly temperature data in this format:
Row1: 05/01/04 hour1, hour2...
Row2: 05/02/04 hour1, hour2...
I need to transpose the columns(hours1 through24)so they
are listed into one columnthis must be done for each day
of the month. It should look like:

05/01/04 hour1
05/01/04 hour2
05/02/04 hour3...

05/31/04 hour24
For the month of May, I would have 744 rows and one
column. I would like to right code that would do this to
selected data. I am using Excel 2002. Thanks!



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.692 / Virus Database: 453 - Release Date: 28/05/2004