To remove the duplicate site names from the view I had replace the default web part using a Data View web part and then modify the Xslt Rows variable to query only unique site names using the Site ID field value. Figure 2 will show the Xpath code that I am using to remove duplicate site names from the view. This will remove the duplicate site names and only show unique site names within the view. Figure 3 shows the view after I’ve updated the data view web part.
Figure 2
Figure 3
