Transpose irregular blocks of data from Rows to Columns

Dear Developers,

I am desperate need of creating a macro but I have no idea of What macros are, I just know how to run them if I have the code. Could you please help me with my problem? Thanks in advance.

I need to transpose irregular blocks of my data (the list keeps increasing and decreasing) from Column to rows in blocks. I have attached an excel file for your reference, please check the first sheet it has the data which should look like sheet2 after I run the macro. Thank you!

I think, this would be one of the most difficult macros in the world!

Try

Please Login or Register  to view this content.

That's not really transposing. Try this:

Please Login or Register  to view this content.

Hi! Thanks for your response, I am unable to use it for my data. It's giving me an error message. This line 'With Sheets("From this to")' turns yellow when I run the macro. Hence, I am attaching the macro which I have modified using record macro. The issue with this macro is it's too long which makes it exceed 64 kb. Is there any way that I can shorten it? thank you!


First sheet is the raw data and second sheet is the macro. Please help. Thank you!

Hey Jindon!

Thanks for your help. This works. I can't tell you how much helpful this is. You are a genius!!!!