Best way to collate duplicated results

@Liz - crafty?? more like slick or smooth ways of doing it .. lol

@Bobbl - the simplest way to do this, in my opinion, is to create a ‘report tab’ in the sheet and create the column headers that make more sense to you to use (ie typeform column headers are the full text of the question and something like 4xwk makes more sense, to use your example) and then put in the simple formulas that combine the results that you need. In psuedo-code-like english:

• you can connect the separate audiences’ typeform to separate tabs in one Google sheet. and then create a report tab. 
• in cell F2 for example: = count of all values in tabA for the column 4timesaweek where the cell says yes + count of all values in tabB for the column 4timesaweek where the cell says yes
  • using the correct syntax in the sheet would count the number of yes entries for 4 times a week and then add them. 
  • you might want to make it simpler by having a separate cell for the count for each tab
• then you can make your report. 

if you want to pull all the data records from tabs a and b into the reporting tab, based on a filter of 4 times a week being yes, you can do that with the arrayformula() function and some IF() statements - then you can do the above as you need. 

that’s the KISS principle according to voice #5 of 7 in my head to make this work for you.. 

hope it helps and is not too convoluted.. 

des