Data Center, Public Data Reports, Enrollment by Ethnicity & Gender (School Level)

Save as CSV file

Open in Excel and save as Excel file and create a new tab named “RawData”.

Copy A6 to the bottom right

Paste Special Values Only into cell A6 of RawData.

Filter Column A on blmaks only and delete thse records (this eliminate the ethncicity detail).

Delete empty columns B, C & P.