Crosstab confusion

[Deiter]

Hello willing helpers,
I have a table containing two fields of interest.
One is SiteID values which may occur in one or many records.
The second field contains Observer names which can appear once or many times.
The relationship between the two is many to many where by a SiteID can have 1-15 Observers.
I need to create a query similar to a crosstab query where the unique SiteIds form the record name and the Observer forms the Observer name.
However there are in excess of 7000 possible observers. I only want returned the observers that exist for a site.
What do the gurus recommend? Below is a sample set

UID OBSERVER
1-SER taws
1-SP-DF1 Dickman
10-035FL Compiled Park List
10-067FL Nadolny
10-CR Rodd
10-HOFL Matthes
10-NOFL Miller
10-SER taws
100-035-DF1 Brickhill
100-035-DF1 Dwyer
100-035-DF1 Hatton
100-035-DF1 Magrath
100-035-DF1 Maher
100-035-DF1 Moore
100-035-DF2 Brickhill
100-035-DF2 Dwyer
100-035-DF2 Hatton
100-035-DF2 Magrath
100-035-DF2 Maher
100-035-DF2 Moore
100-035-DF3 Brickhill
100-035-DF3 Dwyer
100-035-DF3 Hatton
100-035-DF3 Magrath
100-035-DF3 Maher
100-035-DF3 Moore
100-035FL Compiled Park List
100-067 Nadolny
100-HO Roberts
10-NOFL Roberts
100-035-DF2 taws

The table i would like has each observer for each site in a seperate column
UID OBSERVER1 OBSERVER2 OBSERVER3 OBSERVER4 OBSERVER5 OBSERVER6 OBSERVER7
1-SER taws
1-SP-DF1 Dickman
10-035FL Compiled Park List
10-067FL Nadolny
10-CR Rodd
10-HOFL Matthes
10-NOFL Miller Roberts
10-SER taws
100-035-DF1 Brickhill Dwyer Hatton Magrath Maher Moore
100-035-DF2 Brickhill Dwyer Hatton Magrath Maher Moore taws
100-035-DF3 Brickhill Dwyer Hatton Magrath Maher Moore
100-035FL Compiled Park List
100-067 Nadolny
100-HO Roberts