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.