Merge 2 rows in worksheet

R

Robby

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?
 
B

Bernie Deitrick

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
 
R

Robby

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?
 
B

Bernie Deitrick

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
 
H

HighTide

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
 
Top