Hi,
I really like the ranking question layout (and generally think Limesurvey's just great- big thanks to the develpers). To make it work for my survey, I need the answers to the ranking question stored based on the choice rather than the actual rank number.
So for example, based "Rank your favourite colour", in the CSV response file, you currently would get :

responseid	1	2	3
1	blue	green	red
2	green	red	blue

I would like:

responseid	red	green	blue
1	3	2	1
2	2	1	3

Is this possible to do with the Ranking question? (This is so we can take an average of the options chosen - among other calculations.)

Note:
I had a look at using an alternative question type, array with unique[self] and using some JS from www.limesurvey.org/forum/can-i-do-this-w...for-ranking-question
in order to get the answers the way we'd like, however it's not usable when there's a long list of options (15+), so the Ranking question type would be best to use.

Thanks in advance for any help or suggestions!

Selecting below gives codes in export.

Exports results to application -->Responses-->Answer codes

Thanks OMdev, but I'm not looking for the answer code. I"m looking to traverse the answers, or in other words, replace row with column.
ie. have the answer name (eg. Red) as the column title, and have the rank order (eg. '1' as 1st place) in the row. Similar to how Array by column differs from your usual Array.

create hidden question after ranking question and store ranking order using EM.

Or you reformat this later in your analysis tool.

But there is no way to change the way the question stores its results in the database. Maybe as OMdev suggested by reading the responses into equation questions you might be able to do this. But I am not quite sure how you read the question and transform this later to write it into the equation question.