Report

Hello to all viewers and thanks in advance and reward also.(URGENT)

I have this type of table

Column1 column2

-

---

-

---

A 10

D 20

B 10

D 30

A 40

E 20

I want to report in this way. How can solve this issues in coding.

Column1 column 2 < c column 2 > c

-

---

-

---

-

---

A 10

40

-

---

Subtotal 50

-

---

B 10

D 20

30

-

---

Subtotal 50

-

---

E 20

-

---

Grand total 60 70

-

---

Thanks I advance.

Regard : deep.