Setup Excel relationships to combine two data source

[sbawnh]

Hi,
I have two data sources that I want to combine to one pivot. I hear a data model can accomplish this.

Table1 fields: Customer name, product, Jan sales, Feb sales, Mar sales, Apr sales, May sales, Jun sales.

Table2 fields: Customer name, product, Jul sales, Aug sales, Sep sales, Oct sales, Nov sales, Dec sales.

I can't setup the relationship due to the many to many rule. Any ideas how to combine these two tables?

 

[sbawnh]

The many to many was due to duplicates. Fixed that with a concatenated field.

New problem, if I set it up January-June, when I add July sales, it's just the sum of July sales for all, it's not noticing the existing fields

 

[sbawnh]

To any future googlers: the categorical fields were coming from the wrong table, just had to switch which table they came from. All is well.