Report that inlcudes the deal name and associated companies

Hi,

Some times our deals can have two associated companies. For example, deal 12345 has two associated companies, one is Company ABC, the assoiation lable is ¨primary company¨, and the other associated company is Company DEF, the association lable would be “end user”.

Now I need to create a report, which is a table, that includes the next columnes: the deal name, Primary company name, and end user company name.

So now in my report, I have the next columns:

But I don´t know how to make the first company name filtered by the association label “primary company” and then the second company name filtered by “end user”.

Please help me to create this report.

Thanks!