Combining every other row

You do not need VBA

1. Select and Copy 2000 rows Columns 1 to 10
2. Paste to columns 11 to 20 starting one row down
3. In cells in column 21, enter formula

Formula:

Please Login or Register  to view this content.

Will give either a ZERO or a 1
4. Data filter the 21 columns
5. Use column 21 and select either ZEROs OR 1s (chose the one that gives the correct result in the last row)
6. Delete
7. Select all in Column 21 and sort the data to remove blank rows

NOTE: You need to paste one row UP or one row DOWN - choose the one that puts the data in the correct columns for 20 columns

Before.jpg

After.jpg

Here is a VBA solution:

Please Login or Register  to view this content.

Modify the ranges to meet your exact specifications.

Input on Sheet1
Output on Sheet2

Please Login or Register  to view this content.

You are welcome
Please go to thread tools and mark the thread as solved if that solves your problem

thanks