Convert Horizontal to Vertical Table

Hi there,

I have an excel sheet where dates are in vertical columns and times are in horizontal row. I want to convert all of the data into vertical form. How can I do that? Below is the thing I want to do.

CURRENT FORMAT

00:00 00:30 01:00 01:30 02:00 02:30 03:00 ..................................................................... 23:30
Date 1
Date 2
Date 3
.
.
.
.
Date 365


I WANT TO CONVERT INTO THIS FORMAT

Date 1 00:00
Date 1 00:30
Date 1 01:00
Date 1 01:30
. .
. .
Date 1 23:30

Date 2 00:00
Date 2 00:30
Date 2 01:00
Date 2 01:30
. .
. .
Date 2 23:30

Date 3 00:00
Date 3 00:30
Date 3 01:00
Date 3 01:30
. .
. .
Date 3 23:30

Could you suggest how do I do that? I have also attached the excel sheet with this message. Not sure if it is getting attached.


Look forward to your valuable input in this regard.


Thanks