Table column merging without formulas

[lindhkris]

Hi

I am trying to merge raw data that has been broken down in 4 dimensions into 3 and attached an example of what I mean. In the example you can see what I start with and what I want to end up with. I want to get rid of the dimension "City" without losing any data. I would prefer to solve this without doing any sumifs formula since the combination of rows that I have in my actual data exceeds 10 000. It would mean a lot of work and I do believe there should be an easier way of doing this. When using a pivot I get close to what I am after but each row needs to contain all dimension data like in the example, which is not the case in the pivot (attached Pivot.png).

Can anyone help me?

Best
/ Kristoffer