Thursday, July 18, 2013

yogi_Arrange Single Column Array Into MultiColumn Output Of Specified Number of Columns

                                          Google Spreadsheet   Post  #1290
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Jul 18, 2013
user Francois Jooste (!category-topic/docs/spreadsheets/gyN359kxkgU)
Can a one-dimensional list be re-arranged automatically into a two-dimensional array?
Hello! I have a column list of strings which is arbitrary in length but always obeys the rule that the total number of items in the list is divisible by 7.

I want to re-arrange these values into an array of 7 columns and whatever number rows is required, but I'm having trouble figuring out a way to achieve this elegantly. Please see the following link for an illustration: list to array doc

Can this be achieved with an arrayformula?

Thanks for any guidance!