displaying a table

I'm not sure how to go about this and need some help.
I've got a data extract rather than a properly structure table in SQL.
It looks something like below:

Name: Item:
John Ball
John Racket
Paul Ball
Jim Glove
Jim Ball

What sort of script can I run that will return each name once and then
the Items in as many columns needed to list them all?
I.e. so that it will look like
Name: Item1 Item2
John Ball Racket
Paul Ball
Jim Glove Ball

Regards,
Ciarn<chudson007@.hotmail.com> wrote in message
news:1117191730.138398.189500@.f14g2000cwb.googlegr oups.com...
I'm not sure how to go about this and need some help.
I've got a data extract rather than a properly structure table in SQL.
It looks something like below:

Name: Item:
John Ball
John Racket
Paul Ball
Jim Glove
Jim Ball

What sort of script can I run that will return each name once and then
the Items in as many columns needed to list them all?
I.e. so that it will look like
Name: Item1 Item2
John Ball Racket
Paul Ball
Jim Glove Ball

Regards,
Ciarn

The short answer is that this is usually much easier to do in the front end
than in the database; for the long answer, Google for "dynamic crosstab
queries", and also see this KB article:

http://support.microsoft.com/defaul...kb;en-us;175574

Simon