Hi

If I have a table containing (among others) theese records:

Color Size Number
AA XX 1
AA YY 2
AA ZZ 3
BB XX 4
BB YY 5
BB ZZ 6

Can I then make a select that will return something like:

XX YY ZZ
AA 1 2 3
BB 4 5 6


Regards
Michael