I Am Having One Problem To Show The Data From Database Let Me Explain Clearly
My Table Data Is As Below
| Name | Product | Section | Qty |
| Harish | Product1 | 125% | 2 |
| Ganesh | Product2 | 125% | 3 |
| Harish | Product2 | 100% | 2 |
| Ganesh | Product1 | 100% | 2 |
| Harish | Product1 | 75% | 4 |
| Ganesh | Product2 | 75% | 3 |
In My Database The Data Is Stored As Above, Now I Need To Show It As Below Irrespective Of Controls.
| | Product1 | Product2 | | |
| Name | 125% 100% 75% | 125% 100% 75% | | |
| Harish | 2 --- 4 | --- 2 --- | | |
| Ganesh | --- 2 --- | 3 --- 3 | | |
| | | | | |
This Is How I Should Show The Data Irrespective Of Any Control Please Suggest Me The Concept How To Do it iF Possible Means Please Give Me a Example, I Can Show Data In Any Control Whichever you People Suggest Me But Client's Requirement Is As Above So Can Anybody Help Me To Do So ?