looking to have each product in its own summary column

  • Profile Image
    stonesusann
    Asked on January 07, 2022 at 06:41 PM

    Hi,

    I am looking for the best way to get a quick and easy summary of all my products ordered. Example: Registration, t-shirt and meal ticket. I would like to have an easy way to know how many was ordered and by who. On the summary spreadsheet all three products appear in the same column on the spreadsheet.


    please advise how to get a summary of each product in a sortable fashion.


    Thank you

  • Profile Image
    Vick_W
    Answered on January 08, 2022 at 02:16 AM

    Hi there,

    Unfortunately, there's no option to do this internally.

    A workaround would be to download your submissions in Excel and use your spreadsheet app's Text to Column feature to separate the Product List's data into columns.

    125705_2021-01-23%2023_28_23.jpg

    Refine your spreadsheet's data from there and try to extract the quantity by utilizing the spreadsheet app's search and replace, and Text to Column feature.

    You may refer to the following guide for more related information: Split text into different columns with the Convert Text to Columns Wizard

    You can also try the following:

    Please review these and see if any of these options could work for you.

    If you have further questions, please feel free to contact us.

    Thanks