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