Saturday, June 2, 2012

yogi_Join Non-Zero Entries In A Given Set Of Non-Contiguous Columns And Transpose To Rows For Weekly Meal Plan By Day of The Week

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #573    Jun 02, 2012     www.energyefficientbuild.com.

the solution I have provided here is in reference to user TomSleeUK's question addressed in my earlier blog post http://yogi--anand-consulting.blogspot.com/2012/05/yogijoin-non-blank-entries-in-given.html
the meal data for the days of the week is laid out in range U17:AY35
this data is then summarized into 7 cells -- 1 day of the week per row.