Switching Rows into Columns

Switching Rows into Columns

I have a table proj_ctc_grp_usr:
USER_ID PROJ_ID CTC_GRP_ID
2 1 1
2 1 2
3 1 1
3 1 2
4 2 2
Table**ctc_grp:**
CTC_GRP_ID CTC_GRP_DS
1 Bank Contact
2 Dept2
Table*User*
USER_ID USER_FIRST_NM USER_LST_NM
2 saravanakumar rajkumar
3 Soosai Antony
4 Adam Allen
I am using the below query:
SELECT *
FROM ( SELECT PROJ.PROJ_ID,
CTC_GRP_DS
FROM dbo.Project PROJ
left join dbo.PROJ_CTC_GRP_USER PCGU on
PROJ.PROJ_ID = PCGU.PROJ_ID
left join dbo.CTC_GRP CG on PCGU.CTC_GRP_ID =
CG.CTC_GRP_ID
) data
PIVOT
( MAX(CTC_GRP_DS)
FOR CTC_GRP_DS IN ([Bank Contact],[Dept2])
) pvt4
and getting below output...
PROJ_ID Bank Contact Dept2
1 Bank Contact Dept2
2 NULL Dept2
I am trying to display it in below form...
PROJ_ID Bank Contact Dept2
1 saravanakumarRajkumar, soosaiAntony saravanakumarRajkumar, soosaiAntony
2 NULL AllenAdam...
I tried it & end up with no luck...Pls help on it...