Hello,

When I make an export from the respones of a survey to Excel (multiple choise with remarks/comments) I see the answers in rows. I would like to have the output tilted so that it looks like an statistics export in HTML or PDF. i have looked everywhare, but can't find the magic button in LS. Is there a way it can be done?

The way I want it:
 

The way I see it:
 

Kind regards and thanks in advance.

Not possible. How will you display this in a 2 dimensional Excel sheet, where the rows are the respondents and the columns are the answers?

For multiple choice questions you need multiple columns, because actually you are asking various "yes/no" questions.

Also, how will you analyse the results in your format with statistics tools?

As you show the full wording, I assume that you are not running a statistical analysis, but rather make a qualitative analisis. However, this is not the most common approach.

The feature that you are looking for does not exist in LS.

Thanks for the quick reply!

I see the point, I tried to tilt the results in excel itself. But when I use 'statistics' in HTML, I see the results as I would like to see them in excel (see the original question). My survey looks like this:


When I export statistics in Excel, I don't see the text respones in the same row of the chosen option:


So, a few questions:
1. Is it possible to relate the response to the chosen options? 'ID 1'  or 'ID 3' is not enough.
2. is it possible to have the responses in the same line as the chosen option?
3. Ok, I'm a rookie. Maybe I am doing it all wrong. Should I make a question for each option to choose? 

Kind regards and thanks in advance.

The "statistics feature" of Limesurvey is rather a quick report during fieldwork and not for the final analysis. If you export the responses via Excel you will get all answers of the same person in one row.

Or I don't really understand your problem.

Hi,
what you get when exporting the responses to EXCEL is the usual layout to analyse it with a statistic software like R or SPSS or even Excel.
If you restructure it that your comments are following the data columns you have the structure that each statistic tool uses.
 

Always remember, LimeSurvey is primarily a data collecting tool. For analysis and presentation you should use tools that are made for this.

Joffm