Matching Data's in the Tables

[anwitha]

Hi,

I need to match the data in the attaached sample tables (jan'13 and Feb'13).

Note - Here matching the data means not exactly matching the numbers. If there is an item under A in India for Jan'13, then something should be there in under iteam A in Feb'13 also..similarly should match for all the item and if there is no item found it will updated as 0 and same shoud be there in next month.

I need to validate the data similarly for 200 + Countries as it will take long time..need your input on matching this..


Thanks,
Sambashiva

[:) Sixthsense :)]

Please show the expected result also

[anwitha]

Hi,

The result should be if there is a data under any of the iteam for Jan'13 and then for the same item in next month also some data should be there..

Eg: for India, in Jan'13 under A - 15 is there then for Feb'13 also some numbers (any number except 0) should be there. Similarly if the data is not there for Jan'13 then it will be upated as 0 and the same shold be there for Feb'13.

Hope you understand this..

Thanks,
Anwitha

[:) Sixthsense :)]

I am little bit confused