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
Dishan

Check 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