Forum Discussion
Merge cells with same value
Hello, I am trying to merge cells with same value. I have got data like this A....5 A....3 B...2 B....3 C...1 and I want to get A...8 B...5 C...1 Can you please help?
=LEFT(A1,1)&"…"&SUMPRODUCT((LEFT($A$1:$A$5,1)=LEFT(A1,1))*RIGHT($A$1:$A$5,1))An alternative could be this formula. Then copy the result of the formula and paste only values into range D1:D5. Then apply data -> remove duplicates.