Try the below
--Suppose you have data in ColA and ColB. Use a helper column say Col C
--Enter 1 to 10 in C1:C10 and copy 1 to 10 to C11:C20
--Select the data in ColA to C. Sort Col C in ascending
--Delete Column C

--
Jacob


"PL" wrote:

Hi

I have 10 consecutive rows of data. I wish to insert a blank between each of
these 10 rows, is there a formula or method I can use to do this quickly? I
don't wish to manually insert the rows.

Thanks.