I have data in a table 
ManagerGoals
   EventID   EEID   CustValue
   107        12         JLK
   108        12         Manager
   109        12         50
   107        27         PEN
   108        27         Supervisor
   109        27         60
   107        31         DAV
   108        31         Manager
   109        31         50

Need it like this
EEID   INIT   TITLE   GOALPERC
12      JLK    Manager      50
27      PEN    Supervisor   60
31      DAV    Manager      50

Could be many more records and goal percent may change each month