macro to put duplicated data in rows into columns and then remove duplicates

see my example attached.

Unfortunately our report writer does not want to let me put the ethnicities into separate columns so gives me multiple rows. I want to be able to report as one row of data. I've searched and searched for an easy answer to no avail, and regrettably I have not used VBA code much to be able to write a macro myself. I would appreciate some help.

DIVERS 5.xlsx10.14 KB