Friday, February 14, 2014

yogi_Sorting Table By A Specified Row Rather Than By A Specified Column

                                         Google Spreadsheet   Post  #1526
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Feb-14-2014
post by Duane Roberts question by (.-.) (https://productforums.google.com/forum/#!mydiscussions/docs/KzxSGNFvQJo)

This can sort every cells in a column by its row.
How can I adjust the script so that it will sort the entire column by desired row?
For example,

3 1 2
b d p
s k  j

sorting by row 1 will be

1 2 3
d p b
k  j s
I was trying to modify your script but its been a while since my last programming class and i never done javascripting...
--------------------------------------------------------------------------------------------------------------------------------------------------------