reorder data
 

I have the following spreadsheet:


NAME JOB 20/02/07 27/02/07
Tom Ward ROAD 0 40
Mike Hull BRIDGE 40 40
Tom Ward BRIDGE 40 0

This tells me how many hours per week that a person worked on a certain job.
I would like to view this infor differently by have each person's name once
and replacing hours per week with job name. If a person works on more than
one job a week it should list the jobs in a cell with a comma to divide.

Not sure how to do this. I was thinking of a match/index type table but that
seems very large. is it possible to run a macro?

e