Results 1 to 1 of 1
  1. #1
    Join Date
    Aug 2007

    Unanswered: Shift Rows to Columns in Excelsheet

    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.

    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

    Thanks and Regards,
    Attached Thumbnails Attached Thumbnails FILE1.bmp  
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts