Shift Rows to Columns in Excelsheet

**bhimacg** · 08-21-2007, 09:07 AM

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 [email protected]

Thanks and Regards,
Bhima

**Special-K** · 08-21-2007, 10:03 AM

Can't read JPG image

**Mark@Work** · 08-21-2007, 10:51 AM

From your description of what you are trying to achive,
the TRANSPOSE() function would seem to be the obvious choice.

It can be a bit of a strange function for an inexperienced user since it is an "array" function.

Select the area you want the transposed data to appear in,
Enter =TRANSPOSE( enter the area you want the data to come from )
press the Ctrl shift and enter buttons all at the same time.

Note that the height of the transposed area must be the same as the width of the original area and the width of the transposed area must be the same as the height of the original area.

Alternatively you can get essentially the same effect as TRANSPOSE() using
=INDIRECT(ADDRESS(...))

Mark.