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

Shift Rows to Columns in Excel sheet

11 Views

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.

http://img403.imageshack.us/img403/3127/fileuploadvt7.jpg

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,

Bhima

Message was edited by:

Bhima Chandra Sekhar Guntla