Combining variables from Excel raw datafile

ctek1 if I understand correctly, all data was merged into Column A with the data separated by a space and you need to split it into individual columns. If I'm right, you can use this method in excel or use the "split" function in google sheets.

jmborzick not exactly, basically my data is displayed by variable instead of by question. So, for example, I have a multicode question with 8 response options - I see in the excel 8 iterations of the same questions which forces Qualtrics to read it as a separate question, so when I'm trying to build the crossbreaks, I'm only able to build a table with one answer option (with options having a Yes or No coding - i.e. selected or non selected). What I would like to see is one column for each question instead of a column for each answer. Is there a way to fix it in Qualtrics or Excel? Thank you!

ctek1 I think I understand now. Could you tell me where the data is being exported from? Is it coming directly from the Data & Analysis tab or from within a dashboard?
If from the Data & Analysis tab, make sure that when exporting "Split multi-value fields into columns" is not selected. That being said, I'm unable to determine where a "Yes/No" response would come from if pulling from Data & Analysis. The closest I was able to replicate was a "1" for selected and a blank cell for unselected.

jmborzick - thanks a lot for your help! Your suggestion actually solved my issue:)