I have created a dependent drop down but I want the data for each of them to be displayed in 2 columns.

  • Profile Image
    Asked on April 24, 2016 at 01:25 PM

    Please refer to the form https://form.jotform.me/61065261965458. There is one dependent drop down but I want to have the results in 2 columns not one. How can we do it?

  • Profile Image
    Answered on April 24, 2016 at 02:46 PM

    There are two ways actually. 

    First, with the help of "Split Text to Columns".

    This would require you to add one additional column on the right of the column you want data to split.

    Then, under Data(from the Menu bar) click the "Split Text to Column" option. Then, leave the separator as "Comma".

    Second, would be with the help of "=SPLIT()" function.

    This would, however, require you to add two columns on the right and will leave the original column that holds the data you want to split.

    Here's how it works: "=SPLIT("TEXT OR CELL YOU WANT TO SPLIT", "DELIMITER")"

    Then, you can just hide the column that shows the unsplit data.

    I hope this helps. Let us know if you need any further assistance. Thank you.