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

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

Hi örjan
Welcome to the forum
Why do you need to go that way??
Why not just filter out the Blank cells with the filter option or shift all the data down one row then filter out the blanks?

Originally Posted by pike

Hi örjan
Welcome to the forum
Why do you need to go that way??
Why not just filter out the Blank cells with the filter option or shift all the data down one row then filter out the blanks?

Hi pike,
Thanks for your reply!

Because I need every row to be in the file twice and the first one hidden.

When I have that, I´ll import it to a translation tool where hidden rows are not shown/translated. (I do not know how the tool treats filtered rows.)
When the translation is done and the file exported from the tool, I´ll hopefully will have a file with alternating rows of source and target language.

Yesterday evening I played around until I had this macro:

Please Login or Register  to view this content.

Trouble is, it does not work when the rows are hidden and therefore I must do the hiding afterwards.
I have been thinking about inserting a column with alternating '1' and '2' cells and sort on that. Then I could hide all '1' rows. But it depends on the table being absolutely regular. One missing or extra row and everything goes havoc.

When I posted yesterday I thought maybe it would be possible to somehow first only show non-blanks rows, select, copy, then only show blank rows and insert there. Is it? Would it be more safe?

Regardless of the method I´ll finally use, I have to somehow check that the resulting structure is correct.

BR,
Örjan

ok try this on dummy data to make sure I have started on the correct row

Please Login or Register  to view this content.

This may be slightly quicker

Please Login or Register  to view this content.

your welcome

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save