-
mohammadaslamAsked on August 8, 2020 at 10:00 AM
how the answer or output look like in excel?
-
Vanessa_TReplied on August 8, 2020 at 10:40 AM
The data is stored in one cell. Each column is comma separated, while the rows are added in a new line within the same cell.
Below is an example of how it actually looks when exported to Excel.
Form:
Excel:
-
capability.development2Replied on August 20, 2020 at 12:12 PM
Sorry to jump in but how to split data row1col1, row1col2, row2col1, and row2col2 into 4 different cells? not in 1 cell. while using text to column, the result is Column1:row1col1... etc... (I only consider row1col1, row1col2,row2col1, and row2col2 in 4 different cells)
Thank you
-
roneetReplied on August 20, 2020 at 2:08 PM
Unfortunately, it is not possible to segregate the data from the configurable list into different columns.
You may also take a look at our Grid Report, the information will be separated by columns.
Another alternative would be to use the Input table field:Or, which will work best, to have all fields created with separate basic fields:
Since only that will ensure that each field is exported to separate cells in Excel.
Let us know if you have any further questions.
Thank you!