I have a spreadsheet look as the following:

Name Title Dept Software
Annie Hall Clerk ACCT Adobe 7.0
Office 2003
MS Project 4.5
Tom Joans Analyst IT Adobe 7.0
Office 2000

What I would like to do is to take all the software name and show them as
header in a seperate spreadsheet. If a person has a software which already
exist in the header then it will not repeat the software name, instead it
will show yes under that header for that person. The other spreadsheet I am
trying to create will look like this:

Name Title Dept Adobe7.0 Office2003 MS Project4.5
Office2000
Annie Hall Clerk ACCT Yes Yes Yes


Tom Joans Analyst IT Yes
Yes


Any new software belongs to a person will show on the header line.

I appreciate any help on this.

--
thadi