Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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 .

O1,D1,1

O1,D2,1

O1,D3,2

O2,D1,1

O2.D2,1

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.

Tags:
Not what you were looking for? View more on this topic or Ask a question