Summarizing Input Table Data: options would include: count (the number of responses), sum, average, median... Excel-like functions

Has anyone found a way to quickly and easily summarize Input Table data?

I have a table that's 35 rows and 4 columns. When viewed in Excel or Google Sheet that's 140 discrete columns!

Does anyone have a method for aggregating the results in a 35 x 4 table?

Unfortunately, it is not possible to change how the Input Table displays in the Excel report or the Google Sheets integration, currently each option in the Input Table will be displayed as a single column. 

How would you like to get the information displayed in the Excel report? 

Would you like to receive it like a single field just like it displays in the submissions page? 

Please, let us know, we will be glad to open a feature request on our second level. 

Thanks for the quick response, Kevin.

I'm not sure the how the data is shown in Excel can or should be changed.

However, a data aggregation option in the built-in "Reports" feature would work. Options would include: count (the number of responses), sum, average, median... Excel-like functions, but only viewable in JotForm reports.

This would be a nice-to-have, so it's certainly not a requirement. As such, please give it a low priority.

I have forwarded this feature request to our back-end team. You will be notified via this thread if this gets implemented in the future.