Results 1 to 6 of 6

Removing Values with No Data

Threaded View

  1. #1
    Registered User
    Join Date
    11-11-2020
    Location
    Birmingham, AL
    MS-Off Ver
    2016 Professional
    Posts
    3

    Question Removing Values with No Data

    I have data that is situated in a horizontal fashion. (see attachment). I want to show the Row and its corresponding values going down but only show the values labels for those that are not blank. I think if you will look at my attachment, it will make sense. Is this doable in a pivot table? Note that in my real file have many, many columns. I want to eliminate those that are blank for that row header. The highlighted values are the ones that I am referring to, but this will change based on the data.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Removing zero values from dynamic data
    By BigJonF in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-06-2018, 05:54 PM
  2. Replies: 2
    Last Post: 10-31-2016, 09:09 AM
  3. Removing n/a values from vlookup data
    By peakd in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-19-2016, 04:56 PM
  4. Summarizing Data by removing zeroed values
    By Coxy347 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-11-2015, 10:54 PM
  5. How do I maintain data values while removing external links?
    By Alice_F_Quinton in forum Excel General
    Replies: 1
    Last Post: 04-07-2014, 02:14 PM
  6. [SOLVED] Data Analysis: Comparing 3 columns, sorting, removing unique values, display data
    By kmills2626 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-14-2013, 07:27 AM
  7. Removing Data from Pivot with zero values
    By robertguy in forum Excel General
    Replies: 3
    Last Post: 04-23-2009, 03:17 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