Report with (first) information from two separate tabels

[Steg]

I have two tables: a table names and roles (A) and a table with case numbers (B)

Table A

CaseID	Name	Role
1	John	Applicant
1	Jim	Applicant
1	Patrick	Defendant
2	Emma	Applicant
2	Bernard	Defendant

Table B

CaseNr	CaseID
4567	1
4589	2

I need to built a report that show per CaseID, the CaseNr, (first) Applicant and the (first) Defendant. Like this:

CaseNr	Applicant	Defendant
4567	John	Patrick
4589	Emma	Bernard

Is there an easy way to realize this report? 

[amitchandak · Accepted solution]

@Steg , Join A and B on CaseID

Create a Matrix

Row -> B[CaseNr]

Column -> A[Role]

Values = Min(A[Name]) //you can use max/first/last too

[Steg]

Thanks, works perfect.