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

the solution I have provided here is in reference to user TomSleeUK's question addressed in my earlier blog post
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.