A list of software in Excel to show as header
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
|