How Can I Simulate Group_concat In SQL CE?

I am referring to the group concatenation where we get all the values of a single column (of all the rows) grouped into one cell as a concatenated string. I know I can achieve this using temporary tables and cursors in SQL Server. But I cannot have a cursor in SQL CE. I need to add this as a command to a tableadapter in a Dataset Designer. Please let me know if you can think of a workaround.

This is what I want:
Table 1:

Col1 Col2
1 a
1 b
2 c
2 d
2 e

Resultset should be:

Table 2:

Col1 Col2
1 a, b
2 c, d, e