Not sure I understood the previous response, but I think I get the
question.
One solution:

E1 1
E2 10001 (or some number that is more than the number of records that
you exported from SAP)
E3 =E1+1
Copy E3 down
After recalculation, Highlight column E
Copy (Ctrl+C) and Paste Speacial values (Alt, E, S, V)

Sort on Column E, Ascending
Highlight Column E, and Find 10001

Cut the data 10001 down back up to E1
Delete Column I


On Fri, 25 Feb 2005 10:41:51 -0800, "Robby"
wrote:

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?


.