If you rearrage your headers slightly like this
Col A Col B
1 2006
2 Job 1
3 Laura X

This formula is B3 then copied over and down should to the trick.

=IF(SUMPRODUCT(--(Sheet1!$A$3:$A$7=$A3),--(Sheet1!$B$3:$B$7=B$1),--(Sheet1!$C$3:$C$7=B$2))0,"X","")

Just change the references Sheet1!$A$3:$A$7, etc to whatever your actual
data range is. The abosolute references are critical to allow you to copy
over and down.

--
If this helps, please remember to click yes.


"LauraM" wrote:

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.