Transpose Macro

Hello,
I'm looking for a macro to transpose multiple rows of hourly data to one continuous column. It requires a new transpose command at the hour 1 cell of each row. Attached is an example data file.

Thanks