PS Query output column with multiple values to single column

 try using LISTAGG function in expression part . In my case , one class has more than one instructor and I wanted to show them in one column instead of showing them in more than one row  . 

LISTAGG( '[ ' || rtrim(F.NAME) || ' (' || rtrim(E.INSTR_ROLE)  || ')]'   ,',')  WITHIN GROUP (ORDER BY F.NAME) as InstructorName