Need help with this SQL

Giganews Newsgroups
Subject: Need help with this SQL
Posted by:  Phil Hunt (a…
Date: Thu, 15 Aug 2013


I have a table like this

ID    COL1    COL2
1        A
1                    X
1                    Y
1        B
1        C

I have a need to output the table with this result:

1    A    X
1    B    Y
1    C

In other words, I want a minimum numer of rows that will have all the data.

I don't care how the COL1 and COL2 paired out, as long as they are within
the same ID.

Thanks in advance.