Cut and paste?|General Excel Questions & Answers|Excel Forum|My Online Training Hub

Hi there, I think I may struggle to explain what I need help with here but I will try!

In the attached workbook I have two tabs:

Original - the data I get from a company database
Desired - an example of how I want to structure the data that is contained in the "Original" tab

I need to repeat the date and times in column A as new rows in column A, one repeated set of dates and times for each of the columns of data shown in columns B-I.
Then I need to cut and paste the data in column B, then C, then D etc. and paste those values in column B next to the dates and times in column A.

I can do this manually of course but it will take a bit of time. I was trying to think if I could do it using paste special transpose but I couldn't figure that out and kept getting an error about the cut and paste areas not matching anyway.

Can anyone suggest anything to at least maybe speed up the manual approach?

Alan