Row delimit find the matching details then concatenate again

[sn2200]

Hi, i am trying to get the output table using the table 1 & 2, can someone please help? Thank you in advance.

Table 1				Table 2				Table 3	output table
Rec ID	Order No			Order No	Details			Rec ID	Details
1	A, F			A	Apple			1	Apple, Banana
2	B			B	Banana			2	Toys
3	C, G, H			C	Toys			3	Table, Shoes, Chair
4	D, I, J, K			D	Table			4	Tomato, Cabbage, Lettuce, Potato
5	E			E	Shoes			5	Fan
				F	Chair
				G	Tomato
				H	Cabbage
				I	Lettuce
				J	Potato
				K	Fan

[Mathias_Nielsen]

Hi,

See if this will work for you

[Qiu · Accepted solution]

@Mathias_Nielsen 
As per @sn2200 required output. we should join Poisition?

[sn2200]

Thank you so much for your assistance!