Creating pivot from Excel sheet on multi-select answer

%3CLINGO-SUB%20id%3D%22lingo-sub-60447%22%20slang%3D%22en-US%22%3ECreating%20pivot%20from%20Excel%20sheet%20on%20multi-select%20answer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-60447%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20looked%20but%20can't%20figure%20this%20out%20-%20the%20charts%20in%20Forms%20Responses%20look%20great%20even%20with%20multiple-response%20questions.%20I%20downloaded%20the%20responses%20to%20Excel%20and%20I'm%20trying%20to%20recreate%20some%20of%20the%20pivot%20charts%20-%20but%20the%20multi-select%20questions%20export%20as%20semicolon%20delimited%20values.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20Forms%20can%20convert%20to%20a%20chart%2C%20I%20think%20I%20should%20be%20able%20to%20figure%20this%20out%20too%2C%20but%20so%20far%20no.%20Has%20anyone%20done%20this%20yet%3F%20I%20may%20need%20to%20ask%20over%20the%20in%20Excel%20forums%20as%20well%2C%20but%20thought%20I%20would%20start%20here.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3CP%3EMichelle%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-60447%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-70461%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20pivot%20from%20Excel%20sheet%20on%20multi-select%20answer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-70461%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20-%20I%20couldn't%20get%20Flash%20Fill%20to%20break%20it%20out%20but%20Text%20to%20Columns%2C%20based%20on%20%22%3B%22%20did%20break%20it%20out.%20Still%20not%20quite%20what%20I%20wanted%2C%20since%20it%20doesn't%20put%20column%20headers%20in%20right%2C%20but%20it's%20closer.%20Thank%20you%20for%20that%20suggestion.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-70454%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20pivot%20from%20Excel%20sheet%20on%20multi-select%20answer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-70454%22%20slang%3D%22en-US%22%3EOnce%20you%20export%20to%20excel%20using%20flash%20fill%20in%20excel%202016%20will%20separate%20the%20multiple%20response%20answers%3C%2FLINGO-BODY%3E
Contributor

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.

 

Thanks!

Michelle

2 Replies
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.