I want to merge two rows, where a particular cell matches

[sewercider]

Hey All,


I am stumped on the following and would greatly appreciate any help on offer!


I have two rows of data which share a common cell (URL), that I would like to effectively merge like so:


Before:

After:

Can this be done?


Kind regards,
Cas

 

[Michael M]

Is it always col "B" and "D" that will be affected ??
Is a VBA solution OK for you ??

 

[sewercider]

Hey Michael, yes - basically when there is a match with column B, I just want the column D data to appear alongside column C data. VBA should be fine... I haven't employed such a solution before but hopefully can work out!!

 

[Michael M]

Try this....Untested, so test it on a copy

Sub MM2()
Dim lr As Long, r As Long
lr = Cells(Rows.Count, "A").End(xlUp).Row
For r = lr To 2 Step -1
    If Range("B" & r).Value = Range("B" & r - 1).Value Then
        Range("D" & r - 1).Value = Range("D" & r).Value
        Rows(r).Delete
    End If
Next r
End Sub

 

[sewercider]

That worked a treat! Thank you so much. That is incredibly useful, I will be using this quite a bit I reckon!

 

[Michael M]

glad it worked for you....

 

[jtakw]

Cross posted here:

https://www.excelforum.com/excel-ge...re-a-particular-cell-matches.html#post4996493

 

[sewercider]

Cross posted here:

https://www.excelforum.com/excel-ge...re-a-particular-cell-matches.html#post4996493

That a problem? Just hunting for answers!

 

[Michael M]

Cross posting means ther may be other people trying to solve your problem, when others have already done so.....thereby wasting posters time.....and getting them offside !
Please read rule #13 of our posting rules