Thanks Mark.....

Though I was trying to tweak your query for below requirement of mine. Basically there are mutiple columns which can have duplicate values and those need to be concatenated as well.

Table Data

IDCol A Col B Col C

1India VP Mumbai

2Aus Consultant Sydney

2Aus VP Melbourne

3France Consultant Paris

4Swiss SC Zurich

4Swiss Consultant Geneva

4Swiss VP Lusanne

5Germany Consultant Koln

5Germany SC Berlin

Output Data

IDCol A Col B Col C

1India VP Mumbai

2Aus Consultant, VP Sydney, Melbourne

3France Consultant Paris

4Swiss SC, Consultant, VP Zurich, Geneva, Lusanne

5Germany Consultant, SC Koln, Berlin

Again.....Thanks a lot in advance.