-
Cammarata_AlessandroAsked on June 9, 2020 at 4:44 AM
Dear Jotform team,
I hope you are well, I have a form with a configurable list that is connected to an excel sheet.
The responses of the configurable list are all in the same cell as per screenshot below.I was wondering if it was possible to have every new row of a configurable list in a new row in excel?
Kindest regards,
Alessandro
-
Anita_KReplied on June 9, 2020 at 7:34 AM
Hi Alessandro,
thank you for reaching out to us.
Unfortunately, I don't think you can change this within the integration itself.
However, you should be able to achieve this by using the 'Text-to-Column' function in Excel: https://support.microsoft.com/en-us/office/split-text-into-different-columns-with-the-convert-text-to-columns-wizard-30b14928-5550-41f5-97ca-7a3e9c363ed7?ui=en-us&rs=en-us&ad=us
I hope this helps, please let us know if you have further questions.