rearrange data - kind of pivot table

[Dan]

Is there a way to have a query that will from:

Class Topic Name
A English Marc
B Math Dan
C Math Lisa
A English Jhon
A Math Dave
B History Ling

Give a result of:

English Math History
A Marc Dave
Jhon
B Dan Ling
C Lisa

Many thanks,
Dan

 

[Allen Browne]

Use a crosstab query, where:
- Class is the row heading;
- Topic is the column heading;
- Name is the value.

(Hopefully these are not the real field names, as Class and Name are both
reserved words.)

 

[Dan]

Thanks but that give me me a count or other aggregate result but I need a
list of value as per my example.
Any idea?
Thanks

 

[Allen Browne]

A count? Try First in the Total row.

If you actually want a listing of multiple entries at each intersection
point of the matrix, you will need to use a function that returns a
concatenated list, such as this one:
http://allenbrowne.com/func-concat.html