How to Reorganise Data in specific format from verious columns to Row

Dear Friends


I have this spreadsheet where there are thousands of sets of data . Kindly refer to the spreadsheet for better understanding

All I want to do is transpose each set of data from the columns to their respective rows.

Is there a way I could automate / reorganised this through a formula or a macro.

Please let me know...this will save me a lot of time

Regards