Data display - columns/rows

[Guest]

I need help displaying data in a different format.

Data in table:
ID test result = column headers
001 A W
001 B X
002 A Y
002 B Z

Need to display in the following format with only 1 row per ID.
ID A B = column headers
001 W X
002 Y Z

What is the best way to do this?
Thank you!!!

 

[Douglas J. Steele]

Try a crosstab query.

 

[Guest]

Thank you so much! Cross-tab worked like a charm on the 2nd attempt (when I
first tried, I couldn't figure out how to get the values - if I selected an
aggregate function in the wizard, it was not letting me change it to display
the actual values). Thanks again!!!