data consolidation

Hi all,

Is there any example to achieve the task below?

ColA ColB
http://a.com 200
http://a.com/ 100
http://b.com 123

Is there a way to combine http://a.com and http://a.com/ into 1 single row and sum up their value which output will look like http://a.com 300?

Please advise

I think u can use pivot tables to achieve the same. Would that be of interest ?

Originally Posted by pakiyabhai

I think u can use pivot tables to achieve the same. Would that be of interest ?

Thank you, didn't know that excel has this wonderful built in feature. More built in feature for me to learn ahead