How to get multiple row value as a single column

[Sanjiv Kumar]

Hello
        I need help.Suppose I have one table having categoryName,
categoryID, customerName.
EXAMPLE:-
categoryName categoryID customerName
  C1 10 Cust1
  C1 10 Cust3
  C1 10 Cust4
  C2 11 Cust2

In above table Multiple Customers having same Category Name.

How to get customer name which have same category name in a single row
using drill query ?
 Like:-

categoryName customerName
 C1 Cust1,Cust3,Cust4
 C2 Cust2









 -------------------------
Thanks & Regards
   Sanjiv Kumar