logic required!

friends,

there is a report that has the final format like the one below...

LGORT BWART COUNT

102S 105 230

102S 315 118

103S 105 439

103S 315 133

Now, i need to change the format of the report such that it should look like :

LGORT 105 315 TOTAL

102S 230 118 348

103S 439 133 572

i.e. there should be only one entry for each storage loc. and the final col. TOTAL should be the sum of the all the movement types...i have worked it out with a couple of logics and not able to arrive at the soln..pl suggest...thanks all..