Hai Everyone,

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/7...euploadmz7.jpg

In that report , My requirement is I need to format 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.

Please send email to bhima.chandrasekharg@gmail.com

Thanks and Regards,
Bhima