+ Reply to Thread
Results 1 to 3 of 3

Pivot Table - Get secondary row label as new column and keeping its value

  1. #1
    Registered User
    Join Date
    09-19-2013
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    13

    Pivot Table - Get secondary row label as new column and keeping its value

    Hi,

    I am working with a very large file with Sub Account Names and their corresponding IDs. The IDs sit above the Sub Account name in the same column in the pivot table. I need to get them to be side by side (Column A = Sub Account names, Column B = IDs) without the IDs being converted into a value as that changes the ID number.

    Attached is a small example file for the pivot table. Any and all help is greatly appreciated
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    12-17-2013
    Location
    ON, Canada
    MS-Off Ver
    Office 365
    Posts
    91

    Re: Pivot Table - Get secondary row label as new column and keeping its value

    Hi Skum,

    Try clicking a cell in the PT, >Design tab>Report Layout>Show in Tabular Form.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    09-19-2013
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    13

    Re: Pivot Table - Get secondary row label as new column and keeping its value

    Hi Flyboy65,

    Thank you! I did have to change the ID field to "none" for subtotals cause it was adding extra cell space, but that got what I needed. Again thank you so much! I will mark this solved.

+ 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. How to Bring Column labels dynamically to pivot table as the column label is changed
    By JAIGANESH308 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-12-2016, 05:26 AM
  2. Replies: 1
    Last Post: 09-30-2013, 09:52 AM
  3. Replies: 11
    Last Post: 07-18-2013, 05:14 PM
  4. AutoSort issue when sorting Pivot Table after secondary column
    By alienss in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-24-2013, 01:14 PM
  5. Linking column label in Pivot table
    By James_SF in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-07-2011, 10:55 AM
  6. Ling column label in Pivot table
    By James_SF in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-23-2011, 03:10 PM
  7. Keeping column width in Excel pivot table?
    By Polina in forum Excel General
    Replies: 1
    Last Post: 04-03-2006, 12:10 AM

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