Forum Discussion
likert question title does not show up in Microsoft Forms response's spreadsheet
I have an Online Microsoft Forms (office365) that has several 'likert' type questions. The table type question is like: note: The question and items are imaginary just to clarify my...
It looks like you need to transpose the options so that you have three columns: Coffee, Tea, Orange juice with a row for each time of day to get the required entry in the spreadsheet.
Phillip Ruffell not really, as you see I already have the responses on the rows and options on the columns. My question is regarding the question title itself, not the options and answers. I couldn't find a solution to have "What's your ideal time to drink each item" on the columns just like other question types. It seems Microsoft does not populate this type of question properly in the response spreadsheet
- oops... now I see what you mean and you're right in that it only shows the choices but I'm not sure how this could be achieved anyway as each line is like a different choice question. I'll bear this in mind when creating in the future.