What formual to use in order to have tasks written in front of corresponding name

Hi everyone,

I have a group work, and I prepared a "list A". First column contains list of tasks that should be performed, and other columns are coloured according to names of group members, showing the task they should do at a specific dates. Now I want to create a "list B" from "list A" where I have first columns with group member names and in other columns containing name of the task that each group member should at a precific date. What formula I can use to take data from "list A" to "list B". Another problem's that one person might perform several at one specific date.

Thanks