+ Reply to Thread
Results 1 to 4 of 4

Pivot table to display in rows not columns

  1. #1
    Registered User
    Join Date
    09-11-2012
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    8

    Pivot table to display in rows not columns

    Hello There!

    I am working with an excel spreadsheet with linked data from an access database. The data I'm using to pivot is in your standard spreadsheet format but I need the pivot to display the results of the rows not the columns (see attached sample)

    The highlight in yellow is what I want to see in the blue highlight.

    Any ideas?
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,420

    Re: Pivot table to display in rows not columns

    If I understand correctly you want to show values associated with activity dates. If that is the case you could use a 'Slicer', as shown in attached file, or 'Report Filter'.
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Registered User
    Join Date
    09-11-2012
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Pivot table to display in rows not columns

    Thanks JeteMc!!!!!!! That was exactly what I needed! You are perfect!

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,420

    Re: Pivot table to display in rows not columns

    You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools link above your first post. I hope that you have a blessed day.

+ 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. Creating a Pivot Table to display columns of data issue
    By Sven.Bassett in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-18-2016, 04:46 AM
  2. [SOLVED] Get values from varying rows and columns of Pivot Table and enter those in different table
    By Richavlaues in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-25-2016, 10:24 AM
  3. Pivot Table Display Block Rows not Inline Columns
    By AustinLe in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-16-2015, 01:59 PM
  4. Replies: 1
    Last Post: 05-16-2014, 07:34 PM
  5. 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
  6. Replies: 1
    Last Post: 11-29-2012, 06:24 PM
  7. pivot table display data in separate columns
    By Hidai in forum Excel General
    Replies: 6
    Last Post: 01-05-2011, 02:14 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