Power-Pivot - One to Many Relationship - Can this only be done in Access?

[Excel_ZM]

I have two tables (see below). I am trying to get my power-pivot to match what I did in Access, but it is not working.

It is a one to many relationship. One Project can have many Services.

Here is what I want vs want I have.
http://oi65.tinypic.com/10p2cg7.jpg



This is the first table.

Company	Project_ID_Table1
Steve's Company	1
Steve's Company	2
Steve's Company	3
Steve's Company	4
Steve's Company	5
Rick's Company	6
Rick's Company	7

<colgroup><col><col></colgroup><tbody>
</tbody>

This is the second table.

Service_ID	Project_ID_Table2
Service_001	1
Service_002	1
Service_003	2
Service_004	3
Service_005	4
Service_006	5
Service_007	6
Service_008	7
Service_009	7
Service_010	7

<colgroup><col><col></colgroup><tbody>
</tbody>

Thank you