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

    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.

    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
    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
  •