Hullo Everyone out there,

I went to work and tried the PT solution and it worked, well, EXCEPT I
forgot to add a column in my dummy table.
What I'm working with is a column with a payroll number as well as the
name and the task columns.

Can anyone help with this permutation please?

I have a table of staff members and tasks set out as follows (the real
one is a lot bigger)


Payroll
No. Name Task 1 Task 2 Task 3 Task 4 Total
423 Staff member 1 1 2 3 1 7
555 Staff member 2 1 2 4 1 5
108 Staff member 3 3 1 3 5 4
321 Staff member 4 1 2 4 2 9
321 staff member 4 3 1 2 4 10
123 Staff member 5 1 3 3 5 12
432 Staff member 6 4 4 1 1 10
432 Staff member 6 3 2 3 2 10


Thanks,

Janev