can this be done?

[teiben]

I have an excel spreadsheet (a dump from another database) which I'm importing into one table; the fields are named:
name, scenario (there are 3), q1, q2, q3, q4, q5;
I need to create a query which groups together each name and related records, so the query results would be

John Smith, scenario A, 5, 5, 4, 4, 2
John Smith, scenario B, 4, 5, 4, 4, 1
John Smith, scenario C, 5, 3, 4, 4, 2

Any idea's?

 

[ByteMyzer]

Yes, I have an idea. How about posting a sample of the Raw data from the imported table? We can't give you the steps toward a solution if we don't know what you have to work with.