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?
Perhaps a Pivot Table will do that, provided that the data is similar to what you can see in the attached file.