merge If adjacent cells are the same

I would like to merge the 2 or more cells together if the cells to the left are the same.

e.g i am trying to merge "long" togther

if c2=c3 and b2=b3 and a2=a3 then merge c2 with c3
=IF(AND(C2=C3,B2=B3,A2=A3)) then merge c2:c3
then move down and do it again
then once at the end move left and start from the top
then left again

I cant just merge cells that are the same as the grouping will not work like in Gp2 John- tie- big and Paul-Tie-Long

merge cells test.xlsm


Gp1 Gp2 Gp3 Selection
john Hat Long Red
john Hat Long Green
john Hat Short yellow
john Pants Short yellow
john Pants Long blue
john Pants Medium orange
john Pants Extra Long Red
john Tie big Green
Paul Tie Long yellow
Paul Shoes Long Red
Paul Shirt Short Green
Paul Shirt Short yellow
Paul Socks Long yellow
Paul Shoes Medium blue
Paul Shirt Extra Long Red
Paul Shirt big Green
Paul Hat Long yellow
Paul Hat Medium yellow
Paul Pants Extra Long blue
Ringo Pants big orange
Ringo Pants Long yellow
Ringo Hat Long blue
Ringo Hat Long orange
Ringo Pants Medium Red
Ringo Hat Extra Long Green
Ringo Hat big blue
Ringo Pants Long orange
Ringo Pants Long yellow
Ringo Pants Very short blue

Yes i love the pivot table but from that pivot table I am unable to do the next part of the operation which is selecting a cell and then getting that value into another sheet.

So in this case i would like to be able to put a "true" in Column E and then run a macro to grab what ever rows have true and put that whole row into another sheet.

Try the attached

Jindon

That is awesome.

Now I have to try and figure out each part of the code so that i can get it to work on other workbooks I have.

Thank you very much for your help.

Can you mark the thread as "SOLVED"?