Hi
I am uploading data from excel to internal table itab1.
below is my excel data
Dno Lno KNDNR ARTNR FKART KAUFN KDPOS 1 1 12345 10
Itab structure is.
ROW COL VALUE 0001 0001 Dno 0001 0002 Lno 0001 0003 KNDNR 0001 0000 ARTNR 0001 0005 FKART 0001 0006 KAUFN 0001 0007 KDPOS 0002 0001 1 0002 0002 1 0002 0004 12345 0002 0007 10
I want to modify the internal table structure like below
Dno Lno char value 1 1 ARTNR 12345 1 1 KDPOS 10
How to achieve this. pls help me