Skip to Content
author's profile photo
Former Member

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.

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • author's profile photo
    Former Member
    Posted on Aug 23, 2007 at 07:49 AM

    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

    Add comment
    10|10000 characters needed characters exceeded