Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple rows to one column
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
transpose multiple rows into one column | Excel Discussion (Misc queries) | |||
combine multiple rows in one column | Excel Worksheet Functions | |||
Transposing One Column to Multiple Rows | Excel Worksheet Functions | |||
Way to put multiple rows into the same column. | Excel Discussion (Misc queries) | |||
Problem when trying to convert one column with multiple rows to one row with multiple column | Excel Programming |