Requesting Macro for auto transposing mass data

Hello

I have an excel sheet that has data in sets of 4 rows each

Need a macro to auto transpose them to columns, i.e.- each data spread out between 4 columns

Please check attached sample spreadsheet to see what I exactly need.

Also kindly note that there are millions of such data spread over multiple excel sheets, so need a macro code that can run across the length and breadth of a sheet.

Please advise.


Many thanks!
PB

Originally Posted by AB33

Two codes attached
First code result in sheet2
Second code result in new sheet added.

Hi

Many thanks for the code, both of them works perfectly but I prefer going with the matrix one since it automatically adds the headers in the columns.

You have no idea how much time you have saved for me.

Thanks, thanks and many thanks

PB

PB,
You are welcome!
Could you please now close (Mark) this thread as solved? Go in to the top right-hand side of this page, choose "Thread Tools" from the menu, then select "solved" from the drop down menu.

Done...thanks