Hello - I have an Excel worksheet with a crosstab (PivotTable) with: YYMM1 YYMM2 YYMM3 Mfg1 Product1 Prod1YYMM1Value Prod1YYMM2Value Prod1YYMM3Value, etc. Mfg1 Product2 Prod2YYMM1Value Prod2YYMM2Value Prod2YYMM3Value ,etc. Mfg2 Product3 Prod3YYMM1Value Prod3YYMM2Value Prod3YYMM3Value, etc.
I would like to move this to a table that has the schema (Mfg, Product, Year, Month, Value), so I have rows like: MFG1 PRODUCT1 YYMM1 Prod1YYMM1Value MFG1 PRODUCT2 YYMM1 Prod2YYMM1Value MFG2 PRODUCT3 YYMM1Prod3YYMM1Value etc. Is there a component that can do this? I know how to go from the table to the cross tab, but is there an easy way to go back?