Combining cells from Sheet A to sheet B (split up text)

Hi, I have a problem you might be able to help me with,

I have a master document in Excel with people joining for an event, All 500 guests have their single row vertically, and each person has a first name, last name, email, etc. in each column.
So far so good, my guests have chosen a couple of activities on a signup page and when I export that summary in Excel (document b) I get the summary first name, last name, and email activity1 each on its separate row.
This means that because each guest can choose up to 4 activities (they don't have to choose 4, but its minimum of 1 activity), because of that the list is huge with information and rows.

Is it possible to have the activities synced over from document b to my Master document and be displayed in new columns for example Activity 1, Activity 2, Activity 3, or Activity 4 in the same row for that individual person?

Se my example documents attached, the names are just made up in the example

Thank you so much for the help!