yogi_In Form Responses Sheet Separate Multiple Entries In A Cell Into Different Rows

Google Spreadsheet   Post  #2056

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

Separate cell data into different rows

 

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?

I've seen add-ons that can separate first/last names into separate columns, but I need a new row for each name.

Thanks in advance for your help!

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