I have over 3,000 cells in column A which I need to transpose every 5 cells into column B.

Example:
a1
a2
a3
a4
a5
which needs to transpose to B1,C1,D1,E1,F1
a6
a7
a8
a9
a10
which needs to transpose to B2,C2.D2,E2,F2
etc.


Would appreciate any help.