Bug downloading to Excel and CVS

Hi Liz - here you go - you’ll see our 1st question in column B, as I would expect (this is a single answer Q); then instead of the question at the top there are answers spread across columns C-J. 

Hi @Liz, I am experiencing the same problem for my multiple choice questions. Is there anyway to prevent this? It is almost impossible to sort the data when the multiple choice answer options are populating in the column headers

@Liz , thank you. Do you know the use case for the expected behavior where the multiple choice options show in the question column? I’d like to be able to interpret the data and if there is a use case for this I can adjust the process. 

@Liz to rephrase, I’d like to be able to filter the data and also create some pivot tables. I am finding it difficult with the multiple choice options in the column header. Since this is expected behavior, is there a way to work with the data in the expected format that I am not seeing? Or will I need to manually remove the multiple choice options from the column headers to filter and pivot correctly?

@Liz @tcase - i always recommend Connect-iing forms to the spreadsheet of choice Google Sheets or Excel   rather than downloading the data 

here’s a simple form that is a one question quiz:

when you connect it to a google sheet you get the question across the top and all the multiple selections in one column under the question. if you want to parse the choices out into separate columns use the split() function in google sheets

when you look at the results in a downloaded excel file, you are correct that you don’t get the question just the ‘choice option’ as the column headers. When i have done this in the past, i simply edit the downloaded file and add a row above with the question in a merged cell over top of the options. not perfect but it gets me the question text in there

i honestly prefer the connect route to the spreadsheet for the data. 

des