Pivot with multiple values

I have a table as below

Emp ID   |Managers  |Roles

Now when i try to pivot Roles column and values as Managers column, it gives me below output.

Emp ID|Unit head|Biz HR|Ops Controller|Biz HR Manager|Budget Approver

In Biz Hr column it given Error as there are three Biz Hrs for A ID.

Now how can i make table with mulitple rows as below output,

Emp ID |Unit Head |Biz HR |Ops Controller |Biz HR Manager |Budget Appover

Any Help

Mohan V