Transpose every x number

Transpose every x number




Can you help me with doing the following using Macros?

Transpose Every X Number of Rows in the Zoho worksheet.

I have one column saying 'A' with 1200 rows. Using Transpose will be time-consuming at each and every row.

Once I select Column 'A', I would like to have those data transposed.

I am not good at Macros or writing functions. 

I would appreciate it if any of the members assist me.