Join two tables

[Anonymous]

Hi folks,

I'm having problems to join two tables. 

Ex:

I've these table: Project and Reports

Project

abc

def

ghi

jkl

mno

pqr

stu

vwx

yz

Project	Date (DD-MM-YY)	Report 01	Report 02
ghi	01/01/2020	Y	N
jkl	01/01/2020	Y	Y
mno	01/01/2020	Y	Y
pqr	01/01/2020	N	Y
abc	08/01/2020	Y	N
def	08/01/2020	Y	Y
ghi	08/01/2020	Y	Y
jkl	08/01/2020	N	Y
mno	08/01/2020	Y	N
abc	15/01/2020	Y	Y
def	15/01/2020	Y	Y
ghi	15/01/2020	N	Y
jkl	15/01/2020	Y	N
mno	15/01/2020	Y	Y
pqr	15/01/2020	Y	N
stu	15/01/2020	Y	Y
vwx	15/01/2020	Y	Y
yz	15/01/2020	N	Y

And the result I need is 

Project	Date (DD-MM-YY)	Status Report 01	Status Report 02
abc	01/01/2020	Not Reported	Not Reported
def	01/01/2020	Not Reported	Not Reported
ghi	01/01/2020	Reported	Not Reported
jkl	01/01/2020	Reported	Reported
mno	01/01/2020	Reported	Reported
pqr	01/01/2020	Not Reported	Reported
stu	01/01/2020	Not Reported	Not Reported
vwx	01/01/2020	Not Reported	Not Reported
yz	01/01/2020	Not Reported	Not Reported
abc	08/01/2020	Reported	Not Reported
def	08/01/2020	Reported	Reported
ghi	08/01/2020	Reported	Reported
jkl	08/01/2020	Not Reported	Reported
mno	08/01/2020	Reported	Not Reported
pqr	08/01/2020	Not Reported	Not Reported
stu	08/01/2020	Not Reported	Not Reported
vwx	08/01/2020	Not Reported	Not Reported
yz	08/01/2020	Not Reported	Not Reported
abc	15/01/2020	Reported	Reported
def	15/01/2020	Reported	Reported
ghi	15/01/2020	Not Reported	Reported
jkl	15/01/2020	Reported	Not Reported
mno	15/01/2020	Reported	Reported
pqr	15/01/2020	Reported	Not Reported
stu	15/01/2020	Reported	Reported
vwx	15/01/2020	Reported	Reported
yz	15/01/2020	Not Reported	Reported

Could anyone help me?

Tks!!!

[Mariusz · Accepted solution]

Hi @Anonymous 

Probably not the most elegant solution, but it does the job.

Please see the attached.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Anonymous]

It works for me!!

TKS!!!!!!!!