ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how to amend pivot table structure (https://www.excelbanter.com/excel-worksheet-functions/116162-how-amend-pivot-table-structure.html)

Rasoul Khoshravan

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


ShaneDevenshire

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?




All times are GMT +1. The time now is 08:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com