Tuesday, March 1, 2016

yogi_Put Data In Columns A and B Into Specified Number of Columns Of Nominally Same Height

Google Spreadsheet   Post  #2046
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Mar-01-2016
post by: Gabriel Cervo:
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/cEOg5NiwW8A;context-place=topicsearch/Gabriel$20Cervo
Show formatted list in three columns
Here's what's happening:

I have a sheet with two columns. Column 1 has work orders # and Column 2 has the Location. The list has 150 rows. 
I made a second sheet to display, in descending the order numbers.  I used:

=sort(sheet1!A2:B150, 1, TRUE) 

It worked! But it's a looooooong list and I would like to break this list in 3 columns, to display on a vertical monitor all orders at once. How can I do that, and keep it this sheet 2 always ordered descending ?
-------------------------------------------------------------------------------------------------------