Making rows out of columns but not straight crosstab

[ddaugher]

Thanks in advance for an assistance. I have a table that I need to run a query that moves information out of columns to rows but there is no common field to make a crosstab. Here is the example:
Starting with:


Name Like
Bob Blue
Bob Parent
Sue Red
Sue Door
Sue Window
Fred Floor

Ending with:
Name Like1 Like2 Like3
Bob Blue Parent
Sue Red Door Window
Fred Floor


Thank you again.

[June7]

Review

http://forums.aspfree.com/microsoft-...ry-322123.html

http://allenbrowne.com/func-concat.html