I've made a survey in Sharepoint and want to convert the results into something useful in Excel 2003. My problem is the format the responses are in for some questions.
An example of two responses (=two rows) for one question (=one column) can look like this
alternative A;#alternative B;#unique freetext alternative
alternative A;#alternative C
So all alternatives the user selected are in the same column, separated by
What I would like to do is to convert this to
alternative A = 2
alternative B = 1
alternative c = 1
unique freetext alternative = 1
This way it'll be easy to convert to a graph.
How would I go about doing this with the least amount of manual job? There are about 60-70 rows and each row has about 15 - 20 columns with this problem.
I'd guess I would need to somehow count the alternatives, separated by ;#?
If all else fails, I guess I could handle this with a bunch of