Transposing Data

I have a spreadsheet that has 365 rows labeled 1 to 365 and 24 columns labeled 1 to 24. There is data in cell ranges B2:Y367. I want to rearrange this data into a single column in order of Row 1, column 1:24, Row 2, column 1:24 ... Row X, column 1:24. Not sure how to write VB code to do this or know how to use a function in Excel to do this if one exists. Can anyone help me?

Thanks,

NicB.

Is this close to what you want to do?
http://www.datapigtechnologies.com/f...osetables.html

Another way is to use the OFFSET function
Something like this: =OFFSET($C$2,MOD(ROW()-367,365),ROUNDDOWN((ROW()-367)/365,0))

Hope this gave you a hint how to solve your problem.
Ola Sandström

Yes it did! I didn't even think to use a pivot table. Worked like a charm.

Thanks,

NicB.

Good to hear and thanks for the feedback.

Ola Sandström