help with moving redundant data

[anthony warren]

Hi,

I'm new to access and databases in general. Any help with the following problem appreciated.

I have some data with a LOT of redundant info.

e.g.

Forename    Surname    DOB       LevelPassed
Alice       Alsop      1/1/80    level 1
Alice       Alsop      1/1/80    level 2
Alice       Alsop      1/1/80    level 3
Brian       Blessed    25/12/10  level 1
Brian       Blessed    25/12/10  level 2
 

I'd like to make it look like this:

Forename    Surname    DOB       Level1  Level2  Level3
Alice       Alsop      1/1/80    T       T       T
Brian       Blessed    25/12/10  T       T       F
 

How can I do this for a table with several thousand records quickly?

I'm very new to access.

Many thanks

Tony

[sixdonuts]

Are there only three levels, or is there no upper bound to the number of levels a person can pass?

[anthony warren]

Hi sixdonuts,

There is no upper limit. I've also simplified the example slightly, the levelPassed column in the existing table could contain a sentence or two of text.

Many thanks