Monday, November 14, 2011

yogi_Sort Columns By Day Of Week

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
user accquestion said:
How do I sort columns by days of the week Monday-Friday rather than by ascending & descending alpha order?
When downloading to Google Docs, how can you list the days in order Monday-Saturday in columns, now you have to choose alpha order only.  This is what it looks like now:
Friday Monday Saturday Thursday Tuesday Wednesday Grand Total
  0      0       0        0        0        0
  1      5       3        4        1       14
  5      9      13        5       32
-----------------------------

following is one way for solution to the problem