I would appreciate if anyone could help me with this. I'm new to this sort of thing and don't really know where to start. I have a survey results table that looks like this:

user  question  answer
Mike       1       2
Mike       2       1
Mike       3       5
John       1       5
John       2       3
John       3       4

and i have to get the data look like this:

user   q1   q2   q3
Mike   2    1    5
John   5    3    4

I don't mind if this is a SQL server report, .asp web page or a text file, as long as it is readable.

All ideas very welcome.


Hi, I understand that I can't askt anyone to write the whole query, but any pointers would be very appreciated.