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

  • prateekmonga
    Asked on April 24, 2016 at 1: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?

    Jotform Thread 825351 Screenshot
  • Mike_G JotForm Support
    Replied on April 24, 2016 at 2: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".

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

    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")"

    I have created a dependent drop down but I want the data for each of them to be displayed in 2 columns Screenshot 51 Then, you can just hide the column that shows the unsplit data.

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

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