how to avoid text string data from multiple choice answers in Microsoft Form?

%3CLINGO-SUB%20id%3D%22lingo-sub-2538787%22%20slang%3D%22en-US%22%3Ehow%20to%20avoid%20text%20string%20data%20from%20multiple%20choice%20answers%20in%20Microsoft%20Form%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2538787%22%20slang%3D%22en-US%22%3E%3CP%3E1.%20when%20we%20develop%20Forms%2C%20and%20has%20chosen%20multiple%20answers%2C%20the%20response%20in%20Excel%20will%20be%20in%20text%20string.%20The%20more%20choices%20of%20answer%20we%20get%20the%20longer%20strings%20go.%3C%2FP%3E%3CP%3E2.%20it%20is%20difficult%20for%20me%20to%20delimited%20one-by-one%2C%20columns%20into%20rows%2C%20when%20there%20are%20more%20than%2010%20columns%20with%20multiple%20string%20text%3C%2FP%3E%3CP%3E3.%20is%20there%20any%20solution%20for%20this%3F%20if%20possible%20to%20change%20the%20way%20how%20the%20data%20response%20in%20excel%20look%20like...not%20in%20multiple%20text%20strings%20please%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2538787%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2542799%22%20slang%3D%22en-US%22%3ERe%3A%20how%20to%20avoid%20text%20string%20data%20from%20multiple%20choice%20answers%20in%20Microsoft%20Form%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2542799%22%20slang%3D%22en-US%22%3ECan%20you%20post%20some%20(anonymized)%20sample%20data%20please%3F%3C%2FLINGO-BODY%3E
Occasional Visitor

1. when we develop Forms, and has chosen multiple answers, the response in Excel will be in text string. The more choices of answer we get the longer strings go.

2. it is difficult for me to delimited one-by-one, columns into rows, when there are more than 10 columns with multiple string text

3. is there any solution for this? if possible to change the way how the data response in excel look like...not in multiple text strings please

1 Reply
Can you post some (anonymized) sample data please?