>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!!

*   Size numeric fields as needed.

CREATE TABLE FREE Temp (tindex n(1, 0), tvalue n(10, 0), goal n(10, 0))
SELECT Table1
SCAN
   INSERT INTO Temp (tindex, tvalue, goal) VALUES (1, t1, goal1)
   INSERT INTO Temp (tindex, tvalue, goal) VALUES (2, t2, goal2)
   INSERT INTO Temp (tindex, tvalue, goal) VALUES (3, t3, goal3)
ENDSCAN

Jay