+ Reply to Thread
Results 1 to 4 of 4

putting columns side by side in a pivot

  1. #1
    Registered User
    Join Date
    06-04-2014
    Posts
    4

    putting columns side by side in a pivot

    Hi,

    I was wondering if it was possible to have 2 headers in the Column Labels section, but instead of them stacking and having the second header listed in the section appear as a sub header of the one above it, have them simply be put side by side, independent from one another.

    so instead of something like this in the columns,

    Project #1 Project #2
    Date 1, Date 2, Date 3, Date 4, Date 1, Date 2, Date 3, Date 4

    Simply have them like this:

    Project 1, Project 2, Date 1, Date 2, Date 3, Date 4


    Thanks in advance.

  2. #2
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: putting columns side by side in a pivot

    I think, you would need to change the layout by going to Design mode, Report Layout and change it to Show in Tabular Form
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  3. #3
    Registered User
    Join Date
    06-04-2014
    Posts
    4

    Re: putting columns side by side in a pivot

    I already have it set to Tabular form and while this does work for the rows and shows them side by side, the columns are still stacked in the same way.

  4. #4
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: putting columns side by side in a pivot

    From your description, they are separate fields, so no that isn't possible. They will always be grouped within each other - that is the nature of pivot tables.
    Remember what the dormouse said
    Feed your head

+ 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. [SOLVED] Excel 2007 Pivot Table side by side row labels
    By arasan25 in forum Excel General
    Replies: 5
    Last Post: 03-13-2013, 05:21 PM
  2. Help with moving columns from multiple worksheets into one worksheet side by side
    By gary619 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-16-2012, 04:54 PM
  3. [SOLVED] Graphing-Two stacked columns side-by-side per year
    By brwneyeirishlady in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-30-2006, 03:25 PM
  4. [SOLVED] How do I display columns side-by-side in a two Y axis chart?
    By Kristin C in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-05-2006, 07:40 AM
  5. Replies: 1
    Last Post: 03-20-2006, 10:15 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