Forum Discussion
Creating pivot from Excel sheet on multi-select answer
I've looked but can't figure this out - the charts in Forms Responses look great even with multiple-response questions. I downloaded the responses to Excel and I'm trying to recreate some of the pivo...
Once you export to excel using flash fill in excel 2016 will separate the multiple response answers
Thank you - I couldn't get Flash Fill to break it out but Text to Columns, based on ";" did break it out. Still not quite what I wanted, since it doesn't put column headers in right, but it's closer. Thank you for that suggestion.