Say I have a table like this:
Code SQL:
ID	Guess
1	50
1	30
1	20
2	40
2	35
2	25
3	60
3	15
3	25
With "ID" as an Index.

And I want a query that groups by the "ID", and returns all the "Guess" values for each "ID" in the same row, like this:
Code SQL:
ID	Guess1	Guess2	Guess3
1	50	30	20
2	40	35	25
3	60	15	25
How do I do this?