I am tasked with creating a very similar output to the excel output that is generated from the SurveyMonkey application. Most of the answer-to-answer mapping is pretty straight forward, but mapping matrix type questions seems overly complicated. Has anyone come up with a reliable way to map this data in order to export it to a list-based response? The best thing I have come up with is building an in-memory tree mapping the collectors to respondents to questions to answers to (selected) answers.
To me, this seems like a lot of unnecessary mapping, and I'm just wondering if anyone has come up with a better way.
