yogi_Convert Multi Row Single Column Entries Into A Table Of Specified Number Of Columns

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
user Keith Hinkle said:

Can I "transpose" rows into a table by making for example every 10 rows a single row of 10 columns?
for example take 600 rows by 1 column and convert it into at table with 60 rows and 10 columns?

a1

a2

a3

...

b1

b2

b3

......

a1 a2 a3 ...

b1 b2 b3 ...

...

-------------------------------
following is one solution to the problem ...