Analysing data from multiple select/ODK aggregate

Hi;
In excel(2007 and above) you can use the data menu then text to columns to
split your data.

··· On Thursday, April 4, 2013 9:17:17 PM UTC+3, theago...@gmail.com wrote: > > Hi, > > I wondered if anyone had any tips on analysing data gathered using a > 'select multiple' question, with data processed by ODK aggregate > > > At the moment, for each set of responses it produces a string separated by > spaces in each cell, for example: > > 1 2 > 3 > 1 3 4 > 2 4 > > But the problem is, this makes things tricky for data analysis. Sometimes, > I am interested just in everyone who answered '2' - but it isn't possible > to filter the results to see just the people who answered '2' - because > some people answered '1 2', some '2 4' etc. > > > I wondered what your tips were on dealing with this kind of data? > > Thanks! > > TG > >