Is there a more clever way to "transpose" the data in table 1 into table 2? Currently I am scanning table 1 and then evaluating each row using a do case / end case statement in order to identify accounts and creating a mv to hold the more understandable field names in table 2.

Thank you in advance,
Gary De Lecce


Table 1
Account Emp Ckno Date DrCr
recno1 560 1 122 12/1/2008 5,500.00
recno2 220 1 122 12/1/2008 -854.52
recno3 221 1 122 12/1/2008 -552.30
recno4 223 1 122 12/1/2008 -36.52
recno5 140 1 122 12/1/2008 -1,500.00
recno6 597 1 122 12/1/2008 -150.00
recno7 102 1 122 12/1/2008 2,406.66
recno8 560 3 124 12/1/2008 4,251.00
recno9 220 3 124 12/1/2008 -652.21
recno10 221 3 124 12/1/2008 -958.00
recno11 223 3 124 12/1/2008 -55.41
recno12 224 3 124 12/1/2008 -62.51
recno13 140 3 124 12/1/2008 -850.00
recno14 597 3 124 12/1/2008 0.00
recno15 102 3 124 12/1/2008 1,672.87

Table 2
Ckno EMP Gross WH1 WH2 WH3 WH4 WH5 WH6 Net
recno1 122 1 5,500.00 -854.52 -552.30 0.00 -36.52 -1,500.00 -150.00 2,406.66
recno2 124 3 4,251.00 -652.21 -958.00 -55.41 -62.51 -850.00 0.00 1,672.87