Sound like homework to me.  

Is this what IT is in for in the future, those who want other to do the
work for them and get credit for the results.

Niranjan.Aralikatte@i... wrote:
> 
> I have three records as follows
> 
> Col A       Col B     Col C
> 1              A        ABC
> 2              B        DEF
> 1              A        XYZ
> 
> Can I write a query where in I'll the following in the result set
> 
> Col A       Col B     Col C
> 1              A        ABC , XYZ
> 2              B        DEF
> 
> or is there any other solution for this....
> 
> the database that I am talking about is a text Database...i.e, a CSV
> file...
> if creation of new column id required for storing 'XYZ' is also fine