Macro to transpose data into row format

Hi,

I am trying to create a macro that will transpose data in an excel file from column format into row format, the current column format has the 48 time slots for each half hour in a day running down in column C, I need to reshape the data so that the 48 times slots go across in the header row with a row for each day of data for the applicable category (M1, M2 etc.) per month, if that makes sense? I have attached an example file which shows the current format and the required format. If anyone is able to please help with VBA code that will automate this I would be very grateful.

Many thanks in advance

This may not be the most efficent way

But should give the desired outcome

Please Login or Register  to view this content.

Hi thank you very much for the code, I tested it out, it's very quick and almost works perfectly but for some reason it is only transposing the data from the category in column M2 and applies this same data to all the other categories. I have attached an example of the output, I tried to see which part of the code to change but I couldn't work it out which part to tweak?

Thank you

see underlined code for updates.
Have added 3 decimal format to data to make for ease of reading data

Please Login or Register  to view this content.

That's brilliant, it now transposes all data and thank you also for adding in the number formatting, this is much better on the eye.

Really appreciate your help here.

Thank you.

you're welcome.