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

Please see attached file.
HTH,
ikboy

Hi All,

Thanks for your valuable time and inputs.

Croweater - This is what I was looking for. I downloaded the Temp2 sheet that you attached and it has what I require. I will use that.

In regard with the Code part - Sorry I am illiterate in Coding for excel - Where do I paste that?


Thanks

So you create a new sheet (Sheet1 say).
Then you hit Alt + F11 to open the VBA editor. Copy and paste it there.
Then on that same screen hit Run> Run Sub.

That should do it for you.

Yep. It did the trick. Thanks very much.