Get every row of Table B to in each row of Table A

[Applicable88]

Hello,

I cannot use join to get my expected outcome since rows has no primary key which are matching. 

What I have:

Table A

Date		Day
16.01.2023		Monday
17.01.2023		Tuesday
18.01.2023		Wednesday
19.01.2023		Thursday
20.01.2023		Friday

Table B

Task		ID
Mount		1
BUY		2
FETCH		3

How to get this table:

Date		Day		Task		ID
16.01.2023		Monday		Mount		1
16.01.2023		Monday		BUY		2
16.01.2023		Monday		FETCH		3
17.01.2023		Tuesday		Mount		1
17.01.2023		Tuesday		BUY		2
17.01.2023		Tuesday		FETCH		3

Thank you very much in advance. 

Best. 

[JennB]

I am trying to do this exact thing, but the accepted solution doesn't work because I can't complete the step in the first picture. The system greys out the "OK" button and displays an error. But clicking "Show error" does nothing. Any idea what I should do?

[Applicable88]

@JennB , please try with double quotes instead of single quotation marks. 

[JennB]

That worked. Thanks.

[Mahesh0016 · Accepted solution]

@Applicable88 

>>Table A >> Add Custom Column >> With Below Code And Pic.

>> After Create Column >> Expand Table Column >> With Need You Column.

M Code : #"Table B"

@Applicable88 If this post helps, please consider accept as solution to help other members find it more quickly and Appreciate your Kudos.