Merging data with same values

Hello,

Please see attached.

I would like some code to merge the data as per the example. The data to be compared is that in column Y (grouped by Site Code (Column A)). All the values for mouse need to be merged together. The number of instances of "Mouse" per Site Code is flexible. After merging is complete, there should be just one instance of "Mouse" remaining. The data for the other "Mouse" entries (columns Y to AA) should be removed.
I do have code to loop through each site code. The problem I am having is establishing removing the cells to be removed and the merging, so I'd be glad of any help with the coding.

Thanks in advance.