ARRANGING DATA IN PIVOT TABLES

W

willr

I am using a pivot table and I need to rearrange the columns. However,
I have come to learn that the pivot table will not allow me to simply
move one column in place of another. As it is, Column A and Column B
need to be switched. Is there another way to do this?

Thanks,

Will
 
L

Leo Heuser

I am using a pivot table and I need to rearrange the columns. However,
I have come to learn that the pivot table will not allow me to simply
move one column in place of another. As it is, Column A and Column B
need to be switched. Is there another way to do this?

Thanks,

Will
Click to expand...
Will

Select the column header.
From the Pivot table toolbar click "Pivot table"
Choose "Sequence" (or similar. The 10th entry)
 
Top