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

  • Thread starter Thread starter Peter Wilcox
  • Start date Start date
P

Peter Wilcox

I have created a excel document with 9600 records and I
need to merge two rows is that possible.. Please Help...
 
Hi
how do you want to merge the rows exactly. You may give an example
(plain text - no attachment please)
 
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.
 
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
 
Hi
are you sure you mean rows and not columns?

Try something like
=A1 & B1
in cell C1 to merge column A+B
 
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.
 
Hi

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

Regards,
Madhu
 
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
 
Back
Top