Sql Challenge : List Created From Column Data.

Lets say I have a table called MyData.

MyData has two columns, ID (int), and Value (varchar(x) )

Lets say the data in the table looks like this:

ID Value
- -----------
1 A
1 B
1 C
2 A
2 D
3 E
3 F
3 A
3 G

now, is there any way to construct a select statement from this data that will return a dataset that looks like this?

ID ALL_VALUES
- --------------------
1 A,B,C
2 A,D
3 A,E,F,G


In other words, is there a way to combine all the Value field values into one field for each ID?