+ Reply to Thread
Results 1 to 2 of 2

ARRANGING DATA IN PIVOT TABLES

  1. #1

    ARRANGING DATA IN PIVOT TABLES

    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


  2. #2
    Leo Heuser
    Guest

    Re: ARRANGING DATA IN PIVOT TABLES


    <[email protected]> skrev i en meddelelse
    news:[email protected]...
    >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
    >

    Will

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

    --
    Best Regards
    Leo Heuser

    Followup to newsgroup only please.



+ Reply to 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