hello..
let say i have data as below in my gridview:
| DIM | DIM_BI
| QUE_id | ans_1
| ans_2 |
| 1 | CONTENT MGMT
| 1 | 0 | 4 |
| 1 | CONTENT MGMT
| 2 | 0 | 0 |
| 2 | GENERAL ANSWER
| 3
| 1 | 0 |
| 2 | GENERAL ANSWER | 4 | 1 | 0 |
| 3 | CONSULTATION | 5 | 0 | 1 |
| 3 | CONSULTATION | 6 | 1 | 0 |
how do i do to make it as below:
CONTENT MGMT
| ans_1
| ans_2
|
| QUE_ID = 1 | 0 | 4 |
| QUE_ID = 2 | 0 | 0 |
GENERAL ANSWER
| | |
| 3 | 1 | 0 |
| 4 | 1 | 0 |
| CONSULTATION | | |
| 5 | 0 | 0 |
6
| 1 | 0 |
please help someone..i'm in urguent condition..TQ..