Inserting data in workbook

I need to insert rows in worksheet with a specific format to be loaded to sql server. This is code in Sql server that needs to be 

DECLARE @LoopCounter INT = 1
WHILE ( @LoopCounter <= 17)
BEGIN
    
INSERT INTO [dbo].[Load_DalRep]
           ([SamNum]
           ,[RepTR]
           ,[QuarterYear]
           ,[PCC]
           ,[RepDate]
           ,[TrDate]
           ,[DTloaded]
           ,MthEnddate)
     VALUES
           (@LoopCounter,3753,32020,NULL,NULL,NULL,'2020-04-30','2020-04-30')
    SET @LoopCounter  = @LoopCounter  + 1
END

How to duplicate the rows in Datameer. I created one row in Sheet1 manually but need help in repeating it 17 times