Row to Column

Hi experts,

Ex. Data set in TableA

ID, Value
-----
1,A
2,B
1,F
3,C

Expected result set

ID, Value
----
1,A,F
2,B
3,C

Can I do this with T-SQL?

Thanks.

Regards
DishanCheck out

http://www.aspfaq.com/show.asp?id=2529|||Thanks mark|||Hi Mark,

Please tell me how to do the following :

ID Col#1 Col#2
1 A F
2 B
3 C

I want to post the values in seperate columns.

Regards,

Khatri