How to consolidate data within two or more cells without merging? Does anybody have a solution or idea for that:
Example:
You can do that with a so-called pivot table:
There are lots of instructions out there on how to create a pivot table (this depends on your version of Excel), but you need to change at least these options: