insert multiple new lines in one go, at every second row

Hi,

how do you insert multiple new lines in one go, in every second row?

so, this is what it currently looks like:
A
1 Catherine
2 Eamon
3 Tom
4 Joe
5 Mick
6 Ellen

Now I want to insert a new line in between each row:
A
1 Catherine
2 new line
3 Eamon
4 new line
5 Joe
etc etc

easiest is to number the rows in another column

	A	B
1	A Catherine	1
2	B Eamon	2
3	C Tom	3
4	D Joe	4
5	E Mick	5
6	F Ellen	6
7		1
8		2
9		3
10		4
11		5
12		6

then sort by the numbered column

Dear edunne,

You can try with VBA code

Please Login or Register  to view this content.

try it just sort column a and b by column b