I have a problem that needs a creative solution. I have a data set as follows.

Column A Column B Column C
x John 20hrs
x Tim 4hrs
x Mike 5hrs
y John 7hrs
y Tim 9hrs
y Mike 40hrs

Basically think of colA is the project and B is the resource name and C is
the number of hours in that position.

My end result should be something like this:

Project
Name x y
Tim 4 9
Mike 5 40
John 20 7

I can try to reformat the data if needed but can anyone offer a solution?