I have a problem !! - Need to Merge Two Rows !!!!

[Peter Wilcox]

I have created a excel document with 9600 records and I
need to merge two rows is that possible.. Please Help...

 

[Frank Kabel]

Hi
how do you want to merge the rows exactly. You may give an example
(plain text - no attachment please)

 

[Guest]

Row 1 Row 2

George 14
Sam 1
Sam 2
Sam 3


I want it to say

Row 1

George 14
Sam 1
Sam 2
Sam 3


I have several documents and I want them to merge the
most document has 1700 fields that I need merged so I am
trying to find something easy to do.

 

[Peter]

Here is what I have

Row 1 Row 2

Sam 1
Sam 2
Sam 4
Sam 5
Sam 6
Sam 8
Sam 12

Here is what I want it to say

Row 1

Sam 1
Sam 2
Sam 4
Sam 5
Sam 6
Sam 8
Sam 12

 

[Frank Kabel]

Hi
are you sure you mean rows and not columns?

Try something like
=A1 & B1
in cell C1 to merge column A+B

 

[Peter Wilcox]

Okay the function is: =concatenate(C1,"-",A1)

It works great... Then you have to just copy the row of
the new data and then paste special values and then make
and then that is it.

 

[Madhu Ramamurthy]

Hi

You can achieve the same using the 'concatenate' formula.
In column C1, you can use the formula =concatenate(A1,B1).

Regards,
Madhu

 

[Dave Brown]

Peter,
You mean

Col A Col B

You need to concatenate a space in there. In Column 3, put a formula
like =A1&" "&B1 (that's a space between the "", which indicate text)

HTH
Dave