Parse concatenated Sting to columns based off of multiple delimiters

[LAS1]

All, 

I have a form that im pulling from a database. The form has multiple questions, and all of the questions/responses are output into one cell.  Is there an easy to break out the data into columns, based off of multiple delimiters?  

Here is what  the input is 

This is the output I want 

 

[markcurry · Accepted solution]

Hi @LAS1 

See attached, hopefully that does the trick for you....

[LAS1]

@markcurry  your solution helped, but lead to more questions. What if I have multiple rows of questions / answers? See attached for updated and below for how I would like the Results.   2...Etc and 3... are the other questions, etc. 

[markcurry · Accepted solution]

Hi @LAS1 , see the attached workflow.  Because your records are repeating every 43 records, I've added a response number field (1-5) and a Question ID (1-43), but you don't need the Question ID.....

[LAS1]

This is exactly what im looking for! Been stumped for a few days. 

Thanks