Grouping Power Query Column

I am working on a scheduling calender. I can get it to work with single events per day, but this part is throwing me for a loop. I cannot seem to group, or combine the events to singular cells with matching dates. Below is my query:

excel1.png

What I am hoping to achieve is like the following:

excel2.png

Can anyone give me some advice for this? I've tried group columns, and multiple formulas using Text.Combine, but I cannot seem to get anything to work properly.

THANKS!

ok, now tell me what you want to achieve with your tables in Queries ?
because these tables has nothing to do with your pictures

I suppose it should be like this but I am not sure

Date	Number
01/11/2022	ORD-16181M

use From File option and take the table where is data you need, then Merge these tables by appropriate date columns, expand and check if you see what you want

if calendar date suits to only one date from yours table you see one "number", if in your table will be more the same dates as one in your calendar you should see more numbers

it's hard to imagine what you want to do and how your files and tables are organized

edit:
try to attach ALL files required to your project, with detailed description which tables by which column you need to connect and what you want to see as the result