Hi all,

Can someone please help me with the following? Basically, I have a large amount of data that is generated in a vertical format on the sheet named 'RawData' which needs to be transposed into horizontal records on the sheet named "What I Want". I found a soultion to copy and transpose the data but this is quite tedious as the data keeps expanding.

Could someone please help me with setting up a macro that would automate this task? I have tried so many solutions but none worked so far

Thanks for all you support!!!

Report.xlsx