+ Reply to Thread
Results 1 to 8 of 8

How To Move A Column In A Pivot Table

  1. #1
    Forum Contributor
    Join Date
    01-16-2015
    Location
    Istanbul
    MS-Off Ver
    Office 365
    Posts
    928

    How To Move A Column In A Pivot Table

    I want to put the first column right of the most right column in a pivot table. How can I do that?

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: How To Move A Column In A Pivot Table

    Not sure I understand what you are asking, but if you are just trying to rearrange columns, you can do that in the PT "field list" window (where you add or remove columns). just drag the heading up or down
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,648

    Re: How To Move A Column In A Pivot Table

    Select the column header in the pivot table and hover your mouse pointer to the right cell boundary, the pointer will be changed to a move cursor i.e. four direction arrows, left click and drag the column to the desired location.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  4. #4
    Forum Contributor
    Join Date
    01-16-2015
    Location
    Istanbul
    MS-Off Ver
    Office 365
    Posts
    928

    Re: How To Move A Column In A Pivot Table

    I get error. It says "you can't carry the some of the PivotTable report..."

    But here the woman make it. On the video, 4:54

    http://blog.contextures.com/archives...l-pivot-table/

  5. #5
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,648

    Re: How To Move A Column In A Pivot Table

    She is not moving a pivot column instead she is moving a table column.

  6. #6
    Forum Contributor
    Join Date
    01-16-2015
    Location
    Istanbul
    MS-Off Ver
    Office 365
    Posts
    928

    Re: How To Move A Column In A Pivot Table

    After she created a pivot table she double click the pivot table and another table opens.

    She rename column the titles, click any cell on the table and click insert pivot table. So the column she moved belongs to a pivot table.

    Isn't It?
    Last edited by zanshin777; 09-13-2015 at 10:32 AM.

  7. #7
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: How To Move A Column In A Pivot Table

    You get better help on your question if you add a small excel file, without confidential information.

    Please also add manualy the expected result in your file.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  8. #8
    Forum Contributor
    Join Date
    01-16-2015
    Location
    Istanbul
    MS-Off Ver
    Office 365
    Posts
    928

    Re: How To Move A Column In A Pivot Table

    Sorry, you're right. That's not a pivot table.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 09-30-2013, 09:52 AM
  2. pivot table overlap - automaticaly move it
    By pavlos in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-07-2013, 08:33 PM
  3. Replies: 0
    Last Post: 07-22-2011, 10:50 AM
  4. Move (blank) to top of pivot table
    By barpat96 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-14-2008, 07:03 PM
  5. move column total in pivot table to begining
    By flow23 in forum Excel General
    Replies: 0
    Last Post: 12-08-2005, 09:10 AM
  6. Pivot Table VBA code to move a row
    By uclawarren in forum Excel General
    Replies: 0
    Last Post: 10-10-2005, 03:49 PM
  7. Pivot table: order, move to column
    By excelhappy in forum Excel General
    Replies: 0
    Last Post: 05-09-2005, 02:31 PM
  8. [SOLVED] How do I move rows in a pivot table?
    By Tiff in forum Excel General
    Replies: 2
    Last Post: 02-24-2005, 03:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1