-
prateekmongaAsked 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?
-
Mike_G JotForm SupportReplied 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".
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.