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
Bookmarks