Saturday, December 1, 2012

yogi_Sort Rows Of Sheet1 by Number of Columns In Rows In Descending Order


                                          Google Spreadsheet   Post  #901
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Dec 1, 2012
user Drew Clifton said:(http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/BNnorW3xKSw)
Sorting rows in number of contained columns? 
Hi, I have a whole lot of rows, and they all have at least one more column.

Keeping the columns related to the same row, I'd like to sort things so that the rows with the most columns are at the top, descending to the least (only one more column).

Thanks :)

Firefox 17, Mac OS X ML
-----------------------------------------------------------------------------
following is a solution to the problem