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?

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
>
>