X & Y Coordinate return value
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? |
X & Y Coordinate return value
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? |
X & Y Coordinate return value
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? |
All times are GMT +1. The time now is 04:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com