Configurable List: Can we split data into multiple columns in generated report?

I have the configurable list widget on my form and when I download the submissions in excel I'm wondering if there is a way to separate each field such as item, cost, total cost, in it's own column in excel.  Right now it puts it all together so I can really get much data from the way it's laid out.  Maybe there is a better widget to use for this?  Also is there a way for the total cost to calculate automatically? 

Unfortunately, we do not have any built-in option to split the Configurable List widget data into multiple columns in Excel. Some basic calculations are available within a Spreadsheet widget, but submitted data will be still in one column.

To get separate columns and calculations you might consider using standard fields.

How to Perform Form Calculations

Thank you.

Ok thanks.  Is there an option with the standard fields for the user to add another line?

If you need the info to be separated in columns in Excel then you will indeed need to use basic or quick fields, there is not a way to multiply these fields and you will need to add all the set of fields manually. 

You could add a radio button, for example, and ask your user if a new set of fields will be added and then based on the answer you could show the new set of fields. 

Here's a guide that will help you to achieve this: How-to-Show-or-Hide-Fields-Base-on-User-s-Answer

Hope this helps.