+ Reply to Thread
Results 1 to 2 of 2

Displaying certain columns in a pivot based on column information

  1. #1
    Forum Contributor
    Join Date
    09-19-2018
    Location
    England
    MS-Off Ver
    Professional Plus 2013
    Posts
    153

    Displaying certain columns in a pivot based on column information

    Hi all

    I have a spreadsheet that has information in it where I only want to see information from rows that have the dates included.

    I was wondering if a pivot could be done with this information to show the title names down the left hand side then the columns K, L & M which has dates in it.

    This would then allow the user to easily see what the title is and the dates inputted for Idea, Application, Transition (K,L,M) which then filters out the blanks as they haven't had dates assigned.

    I was then thinking the final column in the pivot would simple show the BRM assigned information.

    Is this possible or is there a better way do you think?

    Would this be better as maybe a formula, your expect advice is welcome - please see sheet attached.

    Regards

    Matt
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    7,684

    Re: Displaying certain columns in a pivot based on column information

    If I understand correctly then perhaps the pivot table on Sheet1 of the attached copy of the file will do what you want.
    The slicers are optional.
    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.

+ 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