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
You attached a csv. Please attach the workbook (xlsx) that you describe in your question
Thanks Riny, and apologies - please see the attached, hopefully this one makes sense!
Alan
Power Query is a simple option for this - see attached.
You can also do it using pivot tables but it's a bit more convoluted.
Fantastic Velouria, super simple and it works a treat! Many thanks for the help.
Alan
