How to split data submitted in Dynamic Dropdowns from one to multiple columns?

  • jana.projetovoj
    Asked on December 22, 2020 at 9:29 AM
    Use the data from this column and split them in two different columns
  • Welvin Support Team Lead
    Replied on December 22, 2020 at 9:53 AM

    It's not possible in the widget settings, and it is not possible on the submissions page either. The workaround here would be to integrate your form with Google Sheets and use the split to column feature to separate the data.

    https://support.google.com/docs/answer/6325535

    Or, download the submissions and use the text to columns in MS Excel.

    https://support.microsoft.com/en-us/office/split-a-cell-f1804d0c-e180-4ed0-a2ae-973a0b7c6a23

    I hope that helps.

    Please let us know if you require additional assistance.