Repeatedly copy one row to next row and then hide first row

[örjan]

Hi,

This is my first posting here and I´m kind of overwhelmed and not quite sure I really understood how to search the archives. Please bear with me.

===

In Excel 2007 I have a sheet with 25.000 rows where every even row (2, 4, 6, 8) has text in 11 columns but all uneven (1, 3, 5, 7) rows are empty.

Now I need to

1) copy the content in all even rows to the respectively next uneven row

and then

2) hide then even rows


I have tried some VBA before but perhaps there is an easier way?
And if not, would someone friendly perhaps give a hint about a suitable structure for the macro?

Thanks a lot in advance

Örjan