A Singapore Government Agency Website 

Back to home

Excel responses from table style questions are clumped into one line, how do I separate them?


formsg-logo
Updated by FORMSG
1) Open the excel sheet generated from our Data Collation Tool 2) Select the entire column of the responses 3) Go to the Data tab and choose Text to Columns > Delimit by comma (,).

Was this answer helpful?
Your opinion matters! Be the first to vote.

ask-question-illustration
Need more help?
Get in touch