Could anyone help me transpose an hourly time series for one year where each row represents a day and columns represent each hour in a day. I want it to be transposed into one column where each row represents each hour of a day. Is there an automatic way of doing it. Please find attached the file and the end product format. Thanks a lot.