I want remove all the duplicate entries of Ser.Servername and keep only unique values of Ser.Servername. I attached the Desired_Result_Set

It does not matter what values come up in other columns like IT.InstanceName and Cust.CustomerName.