Hi there!

I am working on a task planner but can't work out how I can get the result I'm looking for. My sample excel (without any sensitive information): sample_taskplanner.xlsx
I already calculated the amount of tasks for each employee and the max value of tasks per employee for each phase (S1, S2 ...). With this information I can create the row 2 in the worksheet "Overview".

I would now like to display all tasks for an employee for the different phases, ordered by priority (MH, SH, NTH = Must Have, Should Have, Nice to Have). If employee 1 has more tasks in phase 1 than employee 2 there should be empty cells for employee 2. An example how the result for the worksheet "Overview" should look like is integrated in the worksheet "Tasks".

Could someone please help me with this? Thanks in advance!