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?

The T wrote:
Queries/New/Design..add table.
Drag your fields down in the order above.
In the Sort/Order row under name and scenario set to Ascending
Then save/run.

Does that work?