Apr 06 2017
- last edited on
Aug 06 2023
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 pivot charts - but the multi-select questions export as semicolon delimited values.
If Forms can convert to a chart, I think I should be able to figure this out too, but so far no. Has anyone done this yet? I may need to ask over the in Excel forums as well, but thought I would start here.
May 16 2017 12:29 PM
May 16 2017 12:40 PM
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.