I work for a marketing team. We had people take a survey at two different locations using GF. I would now like to combine the data. I know you can combine the data in the form of a SPREADSHEET, what I want to then do is see the combined data's pretty pie charts, etc., that are automatically created within the GF results. Is this possible? Again I know you can combine the spreadsheet data simply by copy+pasting from one form to the other, but it seems impossible to combine the data and then have google turn it into pie charts.
Would I have to do this manually in Sheets or Excel? Or would it be easier to create a whole new form and just reenter all combined data into that? IS THERE ANY EFFICIENT WAY TO DO THIS?
Thank you!