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.