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
Pivoting Columns to Rows
Moderators: chulett, rschirm, roy
Pivoting Columns to Rows
--
Raj
Raj