Recordset Concatenation?

[GKWilly]

I'm sure that there is a simple solution to this but I'm having a bad brain day.
I have a table of data as below.

col1 col2
Manders Data Input
Manders Exams
Manders Applications
FBloggs Exams
FBloggs Applications

I'm trying to get results as follows:

col1 col2 col3 col4
Manders Data Input Exams Applications
FBloggs Exams Applications

I've tried using Case statements but cannot get the right result.
Can anyone point me in the direction of any functions/syntax that could help?
Many thanks

Martin

 

[donutman]

Crosstab Query - PART I (Code Generator) faq183-5269.
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]