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