Wow .. if this is possible, this would really help me get my work smoothed out!

Here's a sample of what I wanted to see when I'm done and then a sample of the raw data:

Done:

DRPA 1703.91 43493.18 17801.29 62998.38
DRPU 79.19 0 0 79.19
DRPW 57.6 1950.55 30 2038.15



Befo

DRPA 1703.91 43493.18 17801.29 0 0 0 1703.91 43493.18 17801.29
TOTAL = 62998.38 TOTAL = 0 TOTAL = 62998.38
.................................................. .................................................. ..................................
DRPU 79.19 0 0 0 0 0 79.19 0 0
TOTAL = 79.19 TOTAL = 0 TOTAL = 79.19
.................................................. .................................................. ..................................
DRPW 57.6 1950.55 30 0 0 0 57.6 1950.55 30
TOTAL = 2038.15 TOTAL = 0 TOTAL = 2038.15
.................................................. .................................................. ..................................

Is this possible in written macro?

Thanks!