View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default how to amend pivot table structure

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.

--
Thanks,
Shane Devenshire


"Rasoul Khoshravan" wrote:

Is it possible to amend pivot table structure, exchane row, column and data
position?