I have a sheet that is used to rota certain tasks for people over a weekly period, it is laid out as column A has all the names in (repeted for each of 14 tasks). Column B has all the tasks in, then columns C:G are the 5 days. Columns C:G have an "X" in if that person is on that task that day.
What I am trying to do is translate that table into another that has one (or more) rows for a task, still has the columns for days, but then puts the name into the corresponding cell, so basically, I want to populate the cell in columns C:G with the value in column A, based on criteria for Columns B and C being met, and to look for the next value if already met (as there may be several on that task on that day)
Can anyone please help with this, as I'm stuck on it now.
Thanks
Bookmarks