try using the Consolidate function in Excel
Post back if you need further assisatnce

HTH
--
If this posting was helpful, please click on the Yes button below

Thank You

cheers, francis









"Matthew G" wrote:

I have two sets of data with some duplication between them and want to
combine the two to generate one report.

Eg
In Dept 1 they use Product 1, 2, and 4
In Dept 2 they use product 2, 3 and 4

I want to combine thes to show Depts 1 and 2's usage of all products. Can
it be done?