Google forms at Google Sheets

What does the cell look like with all the answers? Is it separated by commas? As if in your investigation I had selected:

  • Apples
  • banana
  • Orange
  • Grapes

so he would put Apples, bananas, orange, grapes in the cell in google sheets?

If this is the case, as was the case when I conducted an investigation some time ago, you can simply use = SPLIT (A1, ",") (where A1 is the cell with all the answers ticked). This will separate responses in different cells horizontally. If you want it to be vertical, use = TRANSPOSE (SPLIT (A1, ",")).