I have an Excel sheet with multiple rows in this format:
Column A|Column B
label | value
--------|--------
header (merged cells)
labelA |12
labelB |5
labelC |9
header (merged cells)
labelA |13
labelD |8
It's basically a list of labels and values split up over multiple different sections. In reality there are 70-80 labels and all labels are used 5-10 times. I need to create an output on a separate sheet in the following format:
Column A|Column B
label | Total sum
--------|----------
labelA |25
labelB |5
labelC |9
labelD |8
Ideally the first sheet can be dynamically updated, with new labels reflecting immediately in the second sheet.
I'm sure I can create a macro to accomplish this, however I don't want to add macros if I do not have to. The data is not currently in a pivot table. Is there any way to accomplish this without those solutions?