change column to rows

[Former Member]

Hi experts,

How to change columns to rows and row to columns in executable program . Any function modules(se 37)

or any class(se24) are there please give me suggestions.

Thank you,

dinesh reddy.

[Former Member]

Hi experts,

How to change columns to rows and row to columns in executable program . Any function modules(se 37)

or any class(se24) are there please give me suggestions.

Thank you,

dinesh reddy.

[Former Member]

Hi:

Through the ABAP coding, you can do as you want.

Regards

Shashi

[viquar_iqbal]

Hi

please check this link

It on the same topic

[former_member632729]

Hi Dude,

If the rows and coloums are fixed then you have to write a code to change the rows and coloums ...

If you dont know the number of rows you are going to get then you need to use field symbols and create the dynamic table and by using this you can handle this...

[Former Member]

Hi,

Use this FM in your ABAP code

CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'

EXPORTING

FILENAME = 'c:/test_data.xls'

I_BEGIN_COL = '1'

I_BEGIN_ROW = '1'

I_END_COL = '10'

I_END_ROW = '10'

TABLES

INTERN = it_tab

EXCEPTIONS

INCONSISTENT_PARAMETERS = 1

UPLOAD_OLE = 2

OTHERS = 3

.

Regards,

Jyothi CH.

[Former Member]

Hi,

check out the FM

ALSM_EXCEL_TO_INTERNAL_TABLE

Regards,

jaya

[Former Member]

Hi,

Try like this.

Select the data.

Right click, Copy

Right click, Paste Special, Transpose.

Thanks,

Neelima.

[Former Member]

hi

[Former Member]

hi