Skip to Content
Former Member
Aug 22, 2007 at 04:04 PM

Shift Rows to Columns in Excel sheet


Hai Everyone,

Executed Web Template and Output of the Report exported to Excel Sheet and Saved it in Local Disk.

After saving the data in Excel Sheet , I need to convert to Rows to Columns

I am facing on problem to convert the Rows in to Columns.

The layout of the excel sheet as given below link for Layout of the report.

In that report , My requirement format is like ENDCUSTOMER | MATERIAL | FISCAL YEAR PERIOD | FORECAST QTY

Without using Transpose I am getting END CUSTOMER and MATERAIL directly.

I am getting problem While shifting rows of Fiscal Year Period and Forecast Qty by using transpose function.

Any one can help me out about my requirement.

Thanks and Regards,


Message was edited by:

Bhima Chandra Sekhar Guntla