Looking for a way to transpose data from columns to records.
Our Sales and Forecast information is summarized in one file in monthly columns. I would l like to use this summarized file in QV. Is there a way to cross this data to transpose monthly buckets from columns to rows.
Fields: Customer, Part #, Product Group, Year, Qty1, Qty2, Qty3, Qty4, Qty5, Qty6, Qty7, Qty8, Qty9, Qty10, Qty11, Qty12. Then there are another 12 fields fields for Amount Values.
In this case Year = 2008(FY)
Qty1= April 2008 , Qty4= July 2008, ...Qty 11= Feb 2009, Qty12 = March 2009.
Would like new table to display Customer, Part #, Product Group, Year, Month_qty, Month_Amt, Month_YYYY.
Would like to cross did data in QV. Can cross table handle this? If yes, how? How will we handle crossing generic names to MM YYYY values?
When I do this, I will generally load the data twice - once to get in the Qty and once to get the Values. Quite straightforward with a fixed format like this using the cross table wizard.
