Minor fix in Martina's query:

SELECT AA."Company Code", AA.Name,
             (SELECT BA.Email + '; '
                 FROM myTable BA
                 WHERE BA.[Company Code] = AA.[Company Code] and BA.[Name] = AA.[Name]
                FOR XML PATH('')
             ) AS Email
  FROM (SELECT DISTINCT "Company Code", NAME 
                FROM myTable
           ) AA

>hello Martina
>
>so far query working fine but duplicate record is still in query output.
>
>Query Out Put:
>Company_Code Name Email
>001 Chung, Kristina abc@xyz.com;asdfg@gmail.com;
>001 Lawrence, Neal abc@xyz.com;asdfg@gmail.com;
>
>002 Gallagher, Marian maza@gmail.com;mazahir.naya@gmail.com;
>002 Steele, Alex maza@gmail.com;mazahir.naya@gmail.com;
>
>003 Hawkins, Stephanie rohit@gmail.com;mprint@pixel.com;
>003 Middleton, Tim rohit@gmail.com;mprint@pixel.com;
>
>004 Frame, Mark shanty@kuwait.com;
>
>Thank You.
>Best Regards,
>Mazahir