how do i get values from multiple cells into one cell

Question

how do i get values from multiple cells for a column into one cell of another table.

I have tblAgenda and tblMeeting.

I want to have all agenda notes from Agenda Daily Note column of tblAgenda into Agenda Column which needs to be computed column on tblMeeting.

 

tblMeeting
ID	Agenda
1
tblAgenda
AgendaID	MeetingID	Day	Agenda daiy Note
1	1	1	This Is day 1, First agenda.
2	1	1	This Is day 1, Second agenda.
3	1	2	This Is day 2,First agenda.
4	1	2	This Is day 2 , Second agenda.
5	1	2	This Is day 2, Third agenda.

How do i achieve this?