I have a sheet, where I need to batch 500 products each containing 26 rows of information (13000 rows). after each batch of 26 there must be a space, which I have set up.

I now need to add in column 1 an SKU number for each batch, starting at SKU-00001 going upto SKU-00500.

I am wondering is there a way of using the drag and fill to run these numbers consecutively in batches of 26, to save me having to edit each one?