yogi_Create A Row For Each Option Selected In Item Field In Data Pulled In 'Form Responses 1' Sheet

                                  Google Spreadsheet   Post  #1694
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jul-11-2014
post by MikeD19: (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/s-26HDXgPSw)
using arrayformula to parse multi item checkbox

Hi Everyone,

I created a form that captures multiple checkbox items. In the responses spreadsheet, I wanted to take column B which is where my checkbox captured all the responses and transform it to another worksheet with each item on its own row along with column C and column D (see columns E,F,G on the desired results worksheet. Any help would be appreciated.

https://docs.google.com/spreadsheets/d/1OK0hhUGg6JVzxwpUN5wCNuP2E6ZqktamVeZlXDPhQ1c/edit#gid=756968817

-------------------------------------------------------------------------------------------------------
in the following I present my convoluted solution

sort by multiple column referances