Hi Guys,
I want to retrive the records as
Val col1 col2 col3
--- ---- ---- ----
1 A B C
1 X Y NULL

From The Table, Having Records shown below using select, pivot table or any other query, but not with cursor.

Thanks in Advance.


Val col1 col2 col3
----------- ----- ----- -----
1 A NULL NULL
1 NULL B NULL
1 NULL NULL C
1 X NULL NULL
1 NULL Y NULL