Pivoting Columns to Rows

[rsomiset]

Hi,

I have the data as follows First line as columns

Scenario , FiscalYear ,CompanyCode ,001 ,002 ,003
Goal , 2009 ,003 ,8 ,7 ,9


I need the data as

Scenario , FiscalYear ,CompanyCode ,Fiscalperiod,AggrBal
Goal , 2009 ,003 , 001, 8
Goal ,2009 ,003 , 002, 7
Goal ,2009 ,003 ,003 , 9

I know that we can pivot to get Aggregated balance column but how can column names made as values for another column (How can we get Fisccal Period Column )

Help me on this really confused with this req

Thanks
Rajesh

[rsomiset]

THANK YOU IT WORKED