Hi, I'm hoping you can help me with a problem. At work I work with a
database of information ( the database is locked, so I can't just add a
report for the info that I need..)

What I have is a list of information - with names, roles, and years. What I
would like to do is find an easy way to have the date information in multiple
columns so we don't print off a new line for each person.

Existing Data

Col A Col B Col C

Laura 2006 Job 1
Laura 2007 Job 1
Bob 2006 Job 2
Bob 2006 Job 1
Bob 2007 Job 1


Ideally I'd like the data displayed as follows (but with years going up to
2009).

Name 2006 Job 1 2006 Job 2 2007 Job 1
2007 Job 2

Laura X
X
Bob X X
X


Any suggestions or tips on how to do this? In my list of data there are
some names repeated up to 30 times, if htat helps.