What does the cell look like with all the answers? Is it separated by commas? As if in your investigation I had selected:
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, ",")).