How can I get each column of the Configurable List to show separately in reports?

  • Profile Image
    Asked on March 20, 2018 at 07:24 PM

    We use the configurable list as a log, up to 8 columns and as many rows as necessary. When exported into a report, this is literally just one, super long, combined row, for all rows and columns. Anyway to separate??

  • Profile Image
    Answered on March 20, 2018 at 10:03 PM

    Unfortunately, it is not possible to split the configurable list widget data to separate columns unless there is only one row of data is entered. Please be noted that the configurable list data will be exported in the same cell for all the rows and columns filled on the form. Though it may be possible to split the columns of the data using Text to Columns option in the Excel, it works only if there is one row. Since multiple rows are added to the configurable list widget, it exports all the row data in the same cell that splits the data to separate rows in the Excel sheet too.