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?

Create a Pivot table from your source data. Place the cursor in the middle of
the source data and Select Data - Pivot Table. A wizard will open up but you
should just be able to select Finish as the default setting should be correct
for what you want. Drag the Names into the left column, the project across
the top and the hours in the middle. You can then format the pivot table to
make it all kinda fancy like using the AutoFormat...
--
HTH...

Jim Thomlinson


"Rookie_User" wrote:

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?

Jim,
I was hoping you would get this - thank you. I appreciate your direction
and extremely QUICK response. I have used what you suggested and it gets me
on the right track. I need to do some formatting to group things into
sections and stuff but I think that is relatively doable. Thank you again
for knowledge and patience.

J....

"Jim Thomlinson" wrote:

Create a Pivot table from your source data. Place the cursor in the middle of
the source data and Select Data - Pivot Table. A wizard will open up but you
should just be able to select Finish as the default setting should be correct
for what you want. Drag the Names into the left column, the project across
the top and the hours in the middle. You can then format the pivot table to
make it all kinda fancy like using the AutoFormat...
--
HTH...

Jim Thomlinson


"Rookie_User" wrote:

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?