Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Consolidate
Hi,
I'm not quite sure how to get what I want to achieve. I've got a spreadsheet with a list of job roles and what training they need, then i have a list of all our training. I want to have a table across the top with the job role and training down the side then ticks(or numbers) when there is training that is needed by a role. Is there any easy way to do this? I've tried a pivot table but it doesn't seem to work? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Consolidate
Hi,
Can you please explain the raw data sheets' format. I believe you want the output somewhat like this.. Training1 Training2 Role1 x Role2 x Role3 x x mozzie wrote: Hi, I'm not quite sure how to get what I want to achieve. I've got a spreadsheet with a list of job roles and what training they need, then i have a list of all our training. I want to have a table across the top with the job role and training down the side then ticks(or numbers) when there is training that is needed by a role. Is there any easy way to do this? I've tried a pivot table but it doesn't seem to work? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200901/1 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Consolidate
The raw data stands as :
Required Training Training 1 Training 2 ...... and the other list is as follows Role 1 Training1 Role1 Training2 etc. as you showed below that is exactly how I wish my ouput to be. Is there a way I can achieve this? "aamerrasheed via OfficeKB.com" wrote: Hi, Can you please explain the raw data sheets' format. I believe you want the output somewhat like this.. Training1 Training2 Role1 x Role2 x Role3 x x mozzie wrote: Hi, I'm not quite sure how to get what I want to achieve. I've got a spreadsheet with a list of job roles and what training they need, then i have a list of all our training. I want to have a table across the top with the job role and training down the side then ticks(or numbers) when there is training that is needed by a role. Is there any easy way to do this? I've tried a pivot table but it doesn't seem to work? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200901/1 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Consolidate
Hi,
Using pivot table on the second sheet, you can easily achieve your required data. Put "Role" in the row lables, "Training" in the column labels and drop "training" in the middle again. Thanks, Aamer mozzie wrote: The raw data stands as : Required Training Training 1 Training 2 ..... and the other list is as follows Role 1 Training1 Role1 Training2 etc. as you showed below that is exactly how I wish my ouput to be. Is there a way I can achieve this? Hi, Can you please explain the raw data sheets' format. I believe you want the [quoted text clipped - 13 lines] role. Is there any easy way to do this? I've tried a pivot table but it doesn't seem to work? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200901/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Consolidate | Excel Discussion (Misc queries) | |||
Consolidate | Excel Discussion (Misc queries) | |||
consolidate | Excel Discussion (Misc queries) | |||
Consolidate | Excel Programming | |||
Consolidate | Excel Programming |