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?

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?

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?


.

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?


.

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?


.