Merging Data that follows 2 conditions

Hi Good Evening people

I'm trying to merge my data with the same "store code/store name"(because on my original data some of my store names does not have a corresponding store code) of the store names and "Item code", then the "quantity" and the "total amount" of the merge data will sum up.

I attach an excel file with expected result for further visualization..

Thanks

Re: Merging Data that follows 2 conditions

Hi Herbds, unfortunately I'm already in the office and mediafire is not allowed here (filtered), so I googled AbleBits to find another installer and I found this
http://www.ablebits.com but the software is a free trial only(I need a lifetime :D) and yes it combines my data but the "quantity and price" didn't some up (I mean it becomes like this --> 2,4,6,7)

Thanks..

Re: Merging Data that follows 2 conditions

Ok thanks but is there other free software(lifetime) does things like that? :D..

or is there a vba codes to do that, so I can just add it to my other codes(vba subs)

Thanks..

Re: Merging Data that follows 2 conditions

anyone?

Re: Merging Data that follows 2 conditions

Hi Herbds, yes I can used pivot but my boss is very choosy he wants me to used our company format not the pivot like format and for Excel 2010 I'm only using the excel 2007 I still didnt try it..poor me Dx