Help getting data from two tables

[Anonymous]

Good day, I have looked everywhere and don't know how to do it

I have two tables one from absense called Table 1 

Name	IP	Date (mm/dd/yyyy)
April Day	1680749	12/27/2022
April Day	1680749	1/4/2023
April Day	1680749	1/5/2023
April Day	1680749	1/12/2023
April Day	1680749	1/13/2023
April Day	1680749	1/19/2023
April Day	1680749	1/27/2023
Edward Patterson	1877321	11/8/2022
Edward Patterson	1877321	11/9/2022
Edward Patterson	1877321	11/10/2022

And the other one has the medical certificates

Begining	End	IP
3/16/2023	3/16/2023	2337266
3/20/2023	3/21/2023	2782871
3/21/2023	3/22/2023	2264595
3/22/2023	3/23/2023	2250748
3/22/2023	3/26/2023	2243652
3/22/2023	3/22/2023	2298473
10/19/2022	10/19/2022	2259796
10/27/2022	11/9/2022	2259796
11/10/2022	11/19/2022	2259796

I want a table that checks if they sent a medical certificate with a column that says proof 

Don't know of it makes sense

But merging doesn't work for mw because not all the data is merging, don't know how to do a conditional column with data from 2 tables.

[Anonymous]

Yes, I could merge by ID but the information is by year and they are various entries of ID in both tables so when I merge information the data doesn't match

For example:

if I merge it looks like this:

Name	IP	Date	Begining of cert	End of cert
Charlie Smith	2250748	1/22/2023	3/22/23	3/23/23
Charlie Smith	2250748	1/23/2023	3/22/23	3/23/23
Charlie Smith	2250748	1/24/2023	3/22/23	3/23/23
Charlie Smith	2250748	2/11/2023	3/22/23	3/23/23
Charlie Smith	2250748	2/12/2023	3/22/23	3/23/23

It doesn't match. 

I think if I can find a way to change the second table from this:

Begining	End	IP
3/16/2023	3/16/2023	2337266
3/20/2023	3/21/2023	2782871
3/21/2023	3/22/2023	2264595
3/22/2023	3/23/2023	2250748
3/22/2023	3/26/2023	2243652
3/22/2023	3/22/2023	2298473
10/19/2022	10/19/2022	2259796
10/27/2022	11/9/2022	2259796
11/10/2022	11/19/2022	2259796

to something like this, in the way that it gives me a new column from each day with a certificate:

Date cert	IP
3/16/23	2337266
3/20/23	2782871
3/21/23	2782871
3/21/23	2264595
3/22/23	2264595

then i can merge both tables by IP and Date and be done with it because it would be one entry for each day.

But don't know

[collinq]

Hi @Anonymous ,

My first question is as to what is the column that you are merging on?  I would guess the key is the ID?  If so, you would do a merge on the ID field, and then you expand the second table field list.