+ Reply to Thread
Results 1 to 3 of 3

Creating a Pivot Table to display columns of data issue

  1. 11-15-2016, 04:03 PM #1
    Sven.Bassett
    Sven.Bassett is offline
    Registered User
    Join Date
    11-15-2016
    Location
    Someset
    MS-Off Ver
    Office 2016
    Posts
    1

    Creating a Pivot Table to display columns of data issue

    Hi,

    I have the below table of data which I want to convert into a Pivot Table so that I can filter on Area Manager. I Still want the sites down the left then across the too the 3 columns for Competitors info, just want it to display the info but can't seem to get the pivot to display more than 1 column, any ideas?

    Thanks



    Table.JPG
    Reply With QuoteRegister To Reply
  2. 11-15-2016, 04:28 PM #2
    dflak
    dflak is offline
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: Creating a Pivot Table to display columns of data issue

    Please attach a workbook with representative, but non-sensitive data. I think we can help you out but I want to get some screen captures of how to set up the pivot table.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
    Reply With QuoteRegister To Reply
  3. 11-18-2016, 04:46 AM #3
    peterrc
    peterrc is offline
    Valued Forum Contributor
    Join Date
    05-11-2013
    Location
    Wales
    MS-Off Ver
    Excel 2010
    Posts
    586

    Re: Creating a Pivot Table to display columns of data issue

    Hi Sven,

    Is the attached what you are after?

    Regards

    peterrc
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Creating a Pivot table from data with Sub columns/headers
    By taketad in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-26-2016, 11:20 PM
  2. [SOLVED] Pivot Table creating numerous columns instead of summing data correctly
    By okcsteve in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 11-13-2014, 10:33 AM
  3. Unwanted filter columns display in Pivot Table created by VBA
    By apo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-06-2013, 05:47 AM
  4. Pivot Table issue --variance columns
    By klopeks in forum Excel General
    Replies: 1
    Last Post: 10-05-2011, 12:35 PM
  5. pivot table display data in separate columns
    By Hidai in forum Excel General
    Replies: 6
    Last Post: 01-05-2011, 02:14 PM
  6. [SOLVED] Display columns side by Side in the Data Area of a Pivot table
    By Sue in forum Excel General
    Replies: 1
    Last Post: 03-20-2006, 10:15 PM
  7. Pivot table issue - counting multiple columns
    By Shakespeare in forum Excel General
    Replies: 0
    Last Post: 03-28-2005, 11:35 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1