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.
Susie