Is there a way to take a pivot table and 'unpivot' it back to a normal spreadsheet?
R Rich C Nov 10, 2003 #1 Is there a way to take a pivot table and 'unpivot' it back to a normal spreadsheet?
E Earl Kiosterud Nov 10, 2003 #2 Rich, A pivot table is not a converted sheet -- it's based on some cells. If you right-click it, Wizard, then go back a step or two in the wizard, you can see the reference to the cells from which the pivot table is built.
Rich, A pivot table is not a converted sheet -- it's based on some cells. If you right-click it, Wizard, then go back a step or two in the wizard, you can see the reference to the cells from which the pivot table is built.
