I am working in DevStudio 7.1 and I have a file as folows:
A B C D E
3 1 .00 253,100.70 A) <$1MM
1 232,160.86 .00 A) <$1MM
10 2 .00 498,955.40 A) <$1MM
2 171,547.10 .00 A) <$1MM
12 3 .00 1,549,985.00 B)$1MM - $5MM
3 1,148,414.02 .00 A) <$1MM
so that I do not have two rows for each item in column 'A'.
Can anyone suggest a solution.
Thanks.

If you have a master To read the file,

TABLE FILE WHATEVER
SUM FIELD2 FIELD3 FIELD4 FIELD5
BY FIELD1
END

or perhaps I'm not understanding the question?

Carol

That will not work as I want the row one of column 4 and row two of column 3 but I do not want to sum column two.
I have tried ACROSS COLUMN TWO but then I get two sets of column with the same names and I do not know how to sum them!

Well if I'm understanding you can do something like
COMPUTE TOT/D12 = C1 + C3;

OR IF YOU just want to do certain fields

COMPUTE TOT/D9 = DEPT1+DEPT2+DEPT3;