Table transpose

[Former Member]

Dear Experts,

I have data in the below format.

Category Month Value

A JAN 10

C FEB 20

B MAR 30

D MAY 40

E APR 50

F JAN 60

F FEB 70

-

---

LIKE THIS.

i want to make report in given format.

Category JAN FEB MAR APR MAY JUN ...........

A----

---

10 0 0 0 0 0

B----

---

0 0 30 0 0 0

C----

---

0 20 0 0 0 0

D----

---

0 0 0 0 40 0

E----

---

50 0 0 0 0 0

F----

---

60 70 0 0 0 0

The above data should come under the assigned months,

Thaks & regards

Anwar

[Former Member]

Hi Anwar,

Check this link

<b>Reward Points if this helps,</b>

Satish