Create a flat file from a repeating table

[efarmer]

I need help in creating a flat file from a repeating table. Can you do this in SQL. Here is an example of what I need:

Brenda Frame 7000024987 A
Brenda Frame 7000024987 B
Brenda Frame 700024987 B

Would like it to look like this:

Brenda Frame,700002498 7,A,B,B

The A, B and B are grades. There can be 100 grades for one person.

Any ideas of how to do this in SQL?