Hi, I have a big Excel challenge in front of myself and I hope that
someone can help me with it. I have attached a file to better show you
what I actually need help for.

Basically I have to merge those cells that have one and the same
title/label. At the same time the values in each column for each pair
of equal labels should be merged and summed.

Do you know an easy way to achieve this result?

Thanks in advance for your time!


+-------------------------------------------------------------------+
|Filename: sample.zip |
|Download: http://www.excelforum.com/attachment.php?postid=5124 |
+-------------------------------------------------------------------+

--
trib
------------------------------------------------------------------------
trib's Profile: http://www.excelforum.com/member.php...o&userid=36682
View this thread: http://www.excelforum.com/showthread...hreadid=566135