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.
[TABLE="width: 234"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Company
[/TD]
[TD]Project_ID_Table1
[/TD]
[/TR]
[TR]
[TD]Steve's Company
[/TD]
[TD="align: right"]1
[/TD]
[/TR]
[TR]
[TD]Steve's Company
[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]Steve's Company
[/TD]
[TD="align: right"]3
[/TD]
[/TR]
[TR]
[TD]Steve's Company
[/TD]
[TD="align: right"]4
[/TD]
[/TR]
[TR]
[TD]Steve's Company
[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]Rick's Company
[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]Rick's Company
[/TD]
[TD="align: right"]7
[/TD]
[/TR]
</tbody>[/TABLE]



This is the second table.
[TABLE="width: 201"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Service_ID
[/TD]
[TD]Project_ID_Table2
[/TD]
[/TR]
[TR]
[TD]Service_001[/TD]
[TD="align: right"]1
[/TD]
[/TR]
[TR]
[TD]Service_002
[/TD]
[TD="align: right"]1
[/TD]
[/TR]
[TR]
[TD]Service_003
[/TD]
[TD="align: right"]2
[/TD]
[/TR]
[TR]
[TD]Service_004
[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]Service_005[/TD]
[TD="align: right"]4
[/TD]
[/TR]
[TR]
[TD]Service_006
[/TD]
[TD="align: right"]5
[/TD]
[/TR]
[TR]
[TD]Service_007[/TD]
[TD="align: right"]6
[/TD]
[/TR]
[TR]
[TD]Service_008[/TD]
[TD="align: right"]7
[/TD]
[/TR]
[TR]
[TD]Service_009
[/TD]
[TD="align: right"]7
[/TD]
[/TR]
[TR]
[TD]Service_010
[/TD]
[TD="align: right"]7
[/TD]
[/TR]
</tbody>[/TABLE]



Thank you