Shift Rows to Columns in Excel sheet

[Former Member]

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

[Former Member]

Bhima,

Would you consider running the report directly in the Analyser and using the Drill down functionality or Change Query - Local View of Bex to achieve this?

Regards

Gill