You could try this

--Sample table and data

CREATE TABLE [DBO].[DOCS]

(ClinicName varchar(50),

ClinicNum INT,

DocName Varchar(50))

INsert INTO [DBO].[DOCS] (ClinicName,ClinicNum,DocName)

SELECT 'Elm Valley Vet Clinic',21629,'MIKE' UNION ALL

SELECT 'Elm Valley Vet Clinic',21629,'MELVIN' UNION...