Robby,

The easiest thing would be to do this:

In cell E1, enter the formula
=A2
Copy to F1:H1.

Select E1:H2 (note that you should select 2 rows, not 1) and copy.

Select E3:H??? (in multiples of 2 rows) and paste.

Then select columns E:H, copy, then pastespecial values.

Then select column E, use Edit Go To... Special.... Blanks, press OK,
then use Edit Delete and choose "Entire Row" and press OK.

HTH,
Bernie
MS Excel MVP

"Robby" wrote in message
...
A B C D
1 I want to add
2 Row two to row1

the result would be:

A B C D E F G H
1 I want to add Row two to row1
2
3

Is there an easy way other than cut and paste for a large
worksheet?


-----Original Message-----
Robby,

The specific cell layout at the start, and where you
want them to go will
greatly impact the solution.

How are the cells laid out, and how do you want them
combined? What do you
mean by add? Examples of before and after would help us
help you....

HTH,
Bernie
MS Excel MVP

"Robby" wrote in
message
...
When I download data from SAP to Excel, each record is
divided into two rows. Other than cut and paste, is
there a way to: add row 2 contents to row 1, add row 4
contents to row 3, etc?


.