Monday, April 4, 2016
yogi_In Form Responses Sheet Separate Multiple Entries In A Cell Into Different Rows
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Apr-04-2016
post by: myxlphlyx:https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/OZkzKr0Kz1w;context-place=forum/docs
I have a Google form where users are entering multiple names separated by a comma (e.g. Joe Smith, Jane, Doe, John Doe). I would like to separate the names into 3 separate rows if possible (e.g. Row 1: Joe Smith. Row 2: Jane Doe. Rown 3: John Doe). Does anyone know how I can do this with a formula or add on?