List creation

I have an event that is one week long (7 days), with three functions happening each day (7 days - 3 columns per day).

There are 11 groups with various number of possible attendees listed in rows. Attendees of a given function is indicated by entry of a 1 or 2 (attending partner), Blank = not attending.

How about just creating a list of attendees on sheet2 for each function. Column A would be the 1st day, 1st function with those attending,
Column B would be the 1st day, 2nd function with those attending.
Column C would be the 1st day, 3rd function with those attending
Column B would be the 2nd day, 1st function with those attending etc...

The list would need to be automatically updated when the attendees status changes, entry or deletion of cell value 1 or 2 (indicating # in party)