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?
One option would be to create a pivot table based on the data.
Another option: let's say the data are in A1:B5.
In D1, enter the formula =UNIQUE(A1:A5)
In E1, enter the formula =SUMIF(A1:A5,D1#,B1:B5)