Closed Thread
Results 1 to 7 of 7

Rearrange data columns in Pivot Table

  1. #1
    hedrew3
    Guest

    Rearrange data columns in Pivot Table

    In a pivot table, how do you rearrange the column order in the data
    section?
    Right now I show columns named A, B, C, and Grand Total.
    I want to be able to rearrange them as follows (for example):
    Grand Total, B, A, C.

    I am using Excel 2000.

    TIA


  2. #2
    JulieD
    Guest

    Re: Rearrange data columns in Pivot Table

    Hi

    i'm not sure if you can move the "grand total" column, but the others can be
    easily re-arranged by just typing the names in the order you want (ensure
    that you don't make any typing errors though), what i mean is,
    click on the A heading and type B
    once you press enter B will now come first and A will be moved
    continue as required.


    Hope this helps
    Cheers
    JulieD

    "hedrew3" <peteg@garlic.com> wrote in message
    news:1105602987.150773.303560@z14g2000cwz.googlegroups.com...
    > In a pivot table, how do you rearrange the column order in the data
    > section?
    > Right now I show columns named A, B, C, and Grand Total.
    > I want to be able to rearrange them as follows (for example):
    > Grand Total, B, A, C.
    >
    > I am using Excel 2000.
    >
    > TIA
    >




  3. #3
    hedrew3
    Guest

    Re: Rearrange data columns in Pivot Table

    JulieD wrote:
    > Hi
    >
    > i'm not sure if you can move the "grand total" column, but the others

    can be
    > easily re-arranged by just typing the names in the order you want

    (ensure
    > that you don't make any typing errors though), what i mean is,
    > click on the A heading and type B
    > once you press enter B will now come first and A will be moved
    > continue as required.
    >


    Julie,

    I tried to type in a new heading in a column but it did not reorder the
    columns. Any ideas?

    TIA

    Pete


  4. #4
    JulieD
    Guest

    Re: Rearrange data columns in Pivot Table

    Hi

    um, always works for me - got to type it EXACTLY and it only rearranges once
    you click in another cell or press enter.
    but just checking:

    you have something along the following lines ...
    ........A..................B......................C.......................D
    3....SumofNums...Department.................
    4.....Location........Accounts........Admin................I.T.
    5.....North...............57..................67....................3

    and you want to see I.T. then Accounts then Admin
    so click in B4, type
    I.T.
    press enter and it should rearrange - as i said i don't think you can move
    the grand total.

    Let me know how you go

    Cheers
    JulieD



    "hedrew3" <peteg@garlic.com> wrote in message
    news:1107544668.052758.115990@l41g2000cwc.googlegroups.com...
    > JulieD wrote:
    >> Hi
    >>
    >> i'm not sure if you can move the "grand total" column, but the others

    > can be
    >> easily re-arranged by just typing the names in the order you want

    > (ensure
    >> that you don't make any typing errors though), what i mean is,
    >> click on the A heading and type B
    >> once you press enter B will now come first and A will be moved
    >> continue as required.
    >>

    >
    > Julie,
    >
    > I tried to type in a new heading in a column but it did not reorder the
    > columns. Any ideas?
    >
    > TIA
    >
    > Pete
    >




  5. #5
    hedrew3
    Guest

    Re: Rearrange data columns in Pivot Table


    JulieD wrote:
    > Hi
    >
    > um, always works for me - got to type it EXACTLY and it only

    rearranges once
    > you click in another cell or press enter.
    > but just checking:
    >
    > you have something along the following lines ...
    >

    ........A..................B......................C.......................D
    > 3....SumofNums...Department.................
    > 4.....Location........Accounts........Admin................I.T.
    > 5.....North...............57..................67....................3
    >
    > and you want to see I.T. then Accounts then Admin
    > so click in B4, type
    > I.T.
    > press enter and it should rearrange - as i said i don't think you can

    move
    > the grand total.
    >
    > Let me know how you go
    >
    > Cheers
    > JulieD
    >
    >


    Ahhh...the light finally came on. Now it works.

    What I kept doing was RENAMING Admin (for ex) to something like 'Human
    Resources', and expecting the pivot table to re-sort - which it does
    not do.

    But now I see what you are saying --- just type in another of the
    column (or row) values and it will rearrange the order.

    Thanks,

    Pete


  6. #6
    JulieD
    Guest

    Re: Rearrange data columns in Pivot Table

    you're welcome

    "hedrew3" <peteg@garlic.com> wrote in message
    news:1107589115.620444.142260@l41g2000cwc.googlegroups.com...
    >
    > JulieD wrote:
    >> Hi
    >>
    >> um, always works for me - got to type it EXACTLY and it only

    > rearranges once
    >> you click in another cell or press enter.
    >> but just checking:
    >>
    >> you have something along the following lines ...
    >>

    > .......A..................B......................C.......................D
    >> 3....SumofNums...Department.................
    >> 4.....Location........Accounts........Admin................I.T.
    >> 5.....North...............57..................67....................3
    >>
    >> and you want to see I.T. then Accounts then Admin
    >> so click in B4, type
    >> I.T.
    >> press enter and it should rearrange - as i said i don't think you can

    > move
    >> the grand total.
    >>
    >> Let me know how you go
    >>
    >> Cheers
    >> JulieD
    >>
    >>

    >
    > Ahhh...the light finally came on. Now it works.
    >
    > What I kept doing was RENAMING Admin (for ex) to something like 'Human
    > Resources', and expecting the pivot table to re-sort - which it does
    > not do.
    >
    > But now I see what you are saying --- just type in another of the
    > column (or row) values and it will rearrange the order.
    >
    > Thanks,
    >
    > Pete
    >




  7. #7
    Registered User
    Join Date
    06-11-2010
    Location
    Manila
    MS-Off Ver
    Excel 2007
    Posts
    29

    Re: Rearrange data columns in Pivot Table

    this is amazing! thanks!!!!

    Quote Originally Posted by JulieD View Post
    you're welcome

    "hedrew3" <peteg@garlic.com> wrote in message
    news:1107589115.620444.142260@l41g2000cwc.googlegroups.com...
    >
    > JulieD wrote:
    >> Hi
    >>
    >> um, always works for me - got to type it EXACTLY and it only

    > rearranges once
    >> you click in another cell or press enter.
    >> but just checking:
    >>
    >> you have something along the following lines ...
    >>

    > .......A..................B......................C.......................D
    >> 3....SumofNums...Department.................
    >> 4.....Location........Accounts........Admin................I.T.
    >> 5.....North...............57..................67....................3
    >>
    >> and you want to see I.T. then Accounts then Admin
    >> so click in B4, type
    >> I.T.
    >> press enter and it should rearrange - as i said i don't think you can

    > move
    >> the grand total.
    >>
    >> Let me know how you go
    >>
    >> Cheers
    >> JulieD
    >>
    >>

    >
    > Ahhh...the light finally came on. Now it works.
    >
    > What I kept doing was RENAMING Admin (for ex) to something like 'Human
    > Resources', and expecting the pivot table to re-sort - which it does
    > not do.
    >
    > But now I see what you are saying --- just type in another of the
    > column (or row) values and it will rearrange the order.
    >
    > Thanks,
    >
    > Pete
    >

Closed Thread

Thread Information

Users Browsing this Thread

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

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