transposing data help needed

[targetx]

I have data that looks like this in FM:

Name Number

Bob 1

Bob 2

Mary 3

Mary 4

Mary 5

And I want to create a report that looks like this:

Bob 1,2

Mary 3,4,5

Any ideas how I do this?

[LiveOak]

Yes, but all the ways I can think of right now are really ugly. What is a record in your file?

-bd