Hi folks. 

I have a spreadsheet from a client that has several (about 10!) different fields containing multiple values separated by commas.  Each field represents a multiple-choice field option is a survey.

For example: 

Field Name: "Priority Tech Investment"

Row 1 Value: "Cybersecurity, Hybrid Cloud, Digital Transformation, Skills"

Row 2 Value: "Cybersecurity, Governance"

In the above case, I would like to split the table by the delimiters into 6 rows:

Field Name: "Priority Tech Investment"

Row 1 value: "Cybersecurity"

Row 2 value: "Hybrid Cloud"

Row 3 value: "Digital Transformation"

Row 4 value: "Skills"

Row 5 value: "Cybersecurity"

Row 6 value: "Governance"

Zoho Analytics does not yet support automaticity splitting fields into rows based on a delimiter. I guess that means I need to try a transformation via SQL script. However, I am unsure how to execute such a script to create the new tables with rows needed.  

Best regards,

Joe