Saturday, October 29, 2011

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 ...