Hello, I have created a monstrosity of a survey with ~3000 columns. A lot of it comes down to the user being able to input a subject, for example bananas, and then the survey generates many questions asking them about their opinions on bananas. The ergonomics of bananas, the appropriateness of its color, beliefs regarding the banana's standing in the fruit kingdom etc. For each subject they enter, the same set of questions are asked.
Does anyone have any suggestions about how to process this data or possibly structure the survey better so that the data on bananas is turned into an actual useful and usable form?