What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
I have created a dependent drop down but I want the data for each of them to be displayed in 2 columns.Asked by prateekmonga 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?
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.