switch column values : Hey guys i have 2 tables like this

  MasterEntries with columns:

**ParishName    AverageMark**

  Hanover         50.00
  Manchester      65.00
  Andrew          70.00

MasterScoreSheet with columns :

**Hanover      Manchester    [St.Andrew]**
 50.00          65.00         70.00

i would like AverageMark column values from  MasterEntries to become the values for the respective columns like this

**Hanover      Manchester    Andrew**
 50.00          65.00         70.00

how can i get this done?.



Please assist . Thanks