Arrange data in row

Hi !

I want to delete alternative row in a worksheet or sorted so that I only have the following arrangements..

I have Data in Rows which as followings

Row 1
Row 2
Row 3
Row 4
Row 5
.
.
so on till 1000 data

I don't want Row 1, 3, 5 .... so on

The result should should be arranged as follows:

Row2
Row4
Row6
.
.
.
so on


Thanks in Advance

Try this:

Please Login or Register  to view this content.

This should work

Please Login or Register  to view this content.

Try this code by Rick Rothstein:

Please Login or Register  to view this content.

Originally Posted by jewelsharma

Try this:

Please Login or Register  to view this content.

Thanks for the help it worked..

Happy to help .
Kindly mark the thread as Solved.

Thank you all for the help! this forum is great !! and you guys too !!

Regards