VBA to quickly transpose data

[mahmed1]

Hi Guys,

I have data set that i receive daily that comes in this format

What i need to do is transpose the data so it looks like this

So the Time and data transposed by column for each day

This is taking me forever to do and would really appreciate your help

Thank You

 

[mahmed1]

Thank u

 

[DanteAmor]

Did you try the macro from post #9?
Or were you able to solve your problem with the query?

 

[mahmed1]

Hi Dante - thank you

I trued both methods and used your VBa version as my colleagues understand how to manipulate That but i do intend to use powerqueryin future...

there was 1 problem i realised afterwards was that columns A to D had merged cells and wouldn’t work so manually i had to unmerge the cella and then all thw blank cells below it filled with the cell above (im sure this could be done in code)

thanks once again

 

[alansidman]

Thanks for the feedback. If you are interested in learning more about PQ, then I urge you to obtain a copy of the book "M is for (Data) Monkey" by Ken Puls and Miguel Escobar. It is available from MrE homepage (The MrExcel Store - Welcome to The MrExcel Store) or from Amazon.