>Unfortunatly, it is not up to me to change the data structure. I know it is not the best structure, but I have to work with it. Normalizing the current table into a temp data sounds very do-able, although I'm not sure how that would be done. Any suggestion?
>THANKS!!

Select "1" AS something, t1 As Tn, Goal1 AS Goal ;
  FROM table1 ;
Union All ;
Select "2" AS something, t2 As Tn, Goal2 AS Goal ;
  FROM table1 ;
Union All ;
Select "3" AS something, t3 As Tn, Goal3 AS Goal ;
  FROM table1 ;
INTO CURSOR crsNorm

SELECT Tn, Goal From crsNorm;
  WHERE Tn In ( SELECT Max(Tn) From crsNorm)