ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Add Columns to Right in Pivot Table (https://www.excelbanter.com/excel-discussion-misc-queries/192392-add-columns-right-pivot-table.html)

Django

Add Columns to Right in Pivot Table
 
Good day everyone, I am working with a pivot table which I am trying to
modify. My problem is I am trying to add columns to my table. Each time I add
the column it adds it to the left side of the table e.g. I am working with
fiscal years which currently ends at FY 2013. I would like to include columns
that goes ot to FY 2020 starting at FY 2014 to the right of FY 2013.
Appreciate any assistance provided.
--
Django

Debra Dalgleish

Add Columns to Right in Pivot Table
 
If the years are all items in the same field, click on one of the FY
headings, then click the A-Z button on the toolbar.
Or, click on one of the headings to select it.
Point to that cell's border, and drag to a new position in the heading row.

Django wrote:
Good day everyone, I am working with a pivot table which I am trying to
modify. My problem is I am trying to add columns to my table. Each time I add
the column it adds it to the left side of the table e.g. I am working with
fiscal years which currently ends at FY 2013. I would like to include columns
that goes ot to FY 2020 starting at FY 2014 to the right of FY 2013.
Appreciate any assistance provided.



--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com



All times are GMT +1. The time now is 04:36 AM.

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