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

P

Peter Wilcox

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

Frank Kabel

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

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.
 
P

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
 
F

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
 
P

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.
 
M

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
 
D

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
 
Top