Patch Thru Duplicate Target Names In Target Report

If the target names in the data contain duplicate entries, it indicates that one or more cells in the representative name column have inconsistent spellings. This could be due to extra spaces or variations in capitalization. To correct this, locate a single cell with the proper spelling, then copy and paste that correct entry throughout the entire column.