Upload data from excel grid into an internal table
I have an excel grid which looks like the following
DI D2 D3
O1 1 1 2
O2 1 1 1
O3 2 2 2
I need to get the crosssection of the D and the O Lines to give the following output in an internal table .
and so on .
Any suggestions on how to proceed with this .Also the D and the O cloums and rows can vary in number
Thanks in advance.