Concatenate 2 rows and sum value (summarize)

[MatheusRuiz]

Hello, hope someone can help me on that. 

I have a table that shows the service contracts that subscribers pay me monthly (the price of a service can change for different customers):

Subscriber	Service	Price
Ana	Positioning	50
Ana	Positioning Plus	60
Ana	Standard	30
Ana	Standard Bonus	40
Ana	Custom	20
Peter	Standard	24
Peter	Standard Bonus	32
Peter	Positioning	50

I would like to conditionally summarize: if the subscriber has positioning plus, then I would like to show only this information but with the price added (positioning + positioning plus = 110). The same for standard with standard bonus, show only "standard" with the price 30 + 40 = 70. The result would be:

Subscriber	Service	Price
Ana	Positioning Plus	110
Ana	Standard	70
Ana	Custom	20
Peter	Standard	56
Peter	Positioning	50

Thanks in advance!

[bhelou]

Hello , try the switch function and sum the balances