Background

I am using an MSForm to gather data from telephone interviews.   I have used power-automate to take the data from each MSForm submission and put it in an excel spreadsheet.

The form is multi purpose using the standard branching functionality with MS Forms.  The route through the form, and hence the data gathered, will vary depending role of the person completing the form and the circumstances they are recording.  However each row will have some values that are common, such as the person making the call, the person being called and the date and time of the call.  In that way there are never any empty rows or columns.

This all appears to work satisfactorily and I have produced pivot tables, charts and dashboards from the excel sheet.  The simplicity of the solution is probably a good thing, partly because of my limited Excel experience and partly to keep maintenance reasonably low tech and simple.  I do have a question though, which has been nagging at me.   

Question

Is this the ‘right’ way to do this?    

I am wondering whether a ‘cleaner’ and possibly more ‘technically correct’, solution would be to try to split out the data using a common ‘key’  field so that each flow through the MSForm would have data stored in a separate spreadsheet or workbook.    From my very limited understanding of databases I believe that is how they work.

I would appreciate any thoughts on this - here are some questions I have in my mind:-

1. Are there any significant down sides to the ‘one sheet’ solution that I have at the moment?
2. Are there any significant benefits to the multi sheet solution?
3. Are there any significant downsides to the multi sheet solution?  I.e. complexity of creation/maintenance of pivot tables, dashboards, charts.

I haven’t created a dummy example file but would be happy to do so if my explanation isn’t clear.

Many thanks in anticipation.

Richard.