PS Query output column with multiple values to single column

I have a query that returns multiple rows for a single applicant.  The only difference in the rows is that the Ethnicity is different.  I would like to have a query return just one row per applicant with the Ethnic Groups in one column.  For example, an applicant might enter two ethnicity into the system.  A basic query would return two rows like the following: 102841 Deputy Sheriff, Recruit 73080 Applicant Sample 050 050-On Eligibility List NULL HISPA M 102841 Deputy Sheriff, Recruit 73080 Applicant Sample 050 050-On Eligibility List NULL WHITE M The goal of the PS Query would