I created a form I used for a quick survey. I added a Likert scale ranging from "not at all" to "totally". I left blank the statements between (i know now that it was a mistake). My Excel sheet only contains the "not at all" and "totally" answers and omits all the answers in between.
How could I make these answers recorded in my Excel sheet? I wrote these statements in between after the survey was completed. It does the trick for the detailed answers Forms gives me in my web browser, but not for the downloaded Excel sheet.
I thought I could be able to merge these two data tables, but it seems the IDs do not match.
Has anybody a solution for me?