yogi_Create Computed Columns For Splitting Row By Row Multiple CheckBox Responses in A Single Cell Into Individual Columns

Google Spreadsheet   Post  #2045

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Feb-29-2016

post by: Roscoe sprong:

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/Wd5MI2r20Eo;context-place=forum/docs
Split multiple responses into single column
Hi all

So I set up a Google Form and a few of the questions are multiple response, 

i.e. Q. Which of the following do you use, Answer = Product A, Product B, Product C..etc.

Now when forms exports the data to google sheets its lists the responses in one column

I.E Person A uses Product A, Product B, Product C

Person B uses  Product B, Product C

Person C uses Product A, Product C

Now I want to link which products are used to a different google sheet (completely new not a new page)

What function can i use so that it will find say just Product A and put it next to the persons name 

Name Email address        Product A     Product B     Product C

Ros    ros@google.com    Yes              Yes             No

I hope this makes sense and thanks in advance 

----------------------------------------------------------------------------------------------------