How to convert rows to comma separated values

Hi, i'm looking for a SQL code (not a stored procedure or a function) to achieve the following.
 Kindly help.

DATA

 NAME              RELATIVE   NAME_ID    RELATIVE_ID      RELATION
JOSHUA	     Jeffrey	         123             346                  Brother
JOSHUA	    Cheyenne          123             459                   Cousin
JOSHUA	     Aryan               123             548                    Friend


Desired OUTPUT

 NAME                  RELATIVES                 NAME_ID      RELATIVE_ID              RELATION
JOSHUA          Jeffrey,Cheyenne,Aryan         123        346,459,548         Brother,Cousin,Friend

Select all Open in new window