Is it possible to amend pivot table structure, exchane row, column and data position?
R Rasoul Khoshravan Oct 26, 2006 #1 Is it possible to amend pivot table structure, exchane row, column and data position?
S ShaneDevenshire Jan 26, 2007 #2 I see no one has addressed this question. You drag the field buttons around the spreadsheet and drop them in a new area. For example, if a field button for Stores is located in the row area you can drag it to the column area and it will become a column field.
I see no one has addressed this question. You drag the field buttons around the spreadsheet and drop them in a new area. For example, if a field button for Stores is located in the row area you can drag it to the column area and it will become a column field.
