Organizing hourly data into daily data

Hi,

I have one row of hourly data for one year, or 8760 entries/columns. I'd like to rearrange it into 365 rows of 24 entries/columns. Does anyone know how I could go about doing this? Thanks in advance for any suggestions.

I would like to help but I have no idea what your data look like. Numbers? To be summed up or averaged? Or is it names of items sold?
Post a workbook with a couple of days of data, that would make it easier.

Hi,

So my data is just numbers. I don't need anything done to them, I just need it rearranged so that instead of having one row of 8760 entries (24 hours over 365 days), I have 365 rows of 24 entries. Does that make sense? Thanks for your help!

I understand what you mean. I can write a macro that will copy and transpose the data but that would mean that the header would repeat every 6 rows in the first column where those 6 rows represent 1 day. Data stretching 24 columns wide where each column represent 1 hour. Is that what you want? I'm not sure it would be that much easier to read but that's up to you.

Thanks for the help. That probably wouldn't do me any good. I just need to figure out a way to transpose one vector column into a 365x24 matrix. Thanks anyway though!