In this video learn how to automatically move Google Forms data in a Google Sheet to separate tabs.
Functions/Features you'll use:
if(): https://support.google.com/drive/answer/3093364
len(): https://support.google.com/drive/answer/3094081
query(): https://support.google.com/drive/answer/3093343
https://developers.google.com/chart/interactive/docs/querylanguage
Data Validation: https://support.google.com/drive/answer/139705?hl=en
Link to spreadsheet: https://docs.google.com/spreadsheets/d/1yW1Kxv2RZBYNzxdf0PUta5FTwlnDIOsqRydrAKBVgbI/
If you want to interact with your own version of the spreadsheet, go to File then Make a copy.