Access or Excel? Column/Row question

[hinklewj]

Hello - I am trying to convert the layout of table 1 below to table 2. Any ideas? Thanks!

Current Layout:
1 Joe
1 Tim
1 Pete
2 Susan
2 Brad
2 Terri
2 Sherry
3 Todd
3 Wendy

Desired Layout:
1 Joe Tim Pete
2 Susan Brad Terri
3 Todd Wendy

 

[Philem]

Hullo. This can be accomplished with a bit of VBA to contantenate records. Take a look on www.mvps.org/access/ in the Module section for a concat function. I've used it to great effect!

HTH

P