Results 1 to 5 of 5

Return values from a pivot table column into a new column

Threaded View

  1. #1
    Registered User
    Join Date
    06-02-2020
    Location
    gabrielzcoelho@hotmail.com
    MS-Off Ver
    2017
    Posts
    6

    Return values from a pivot table column into a new column

    Hi, this is probably a very simple question but I haven't come across this before.
    I have a pivot table where my columns have three possible values: let's say B, C and D.
    Each row has a possible value out of B, C or D and it's represented by a 1. So for example in row 13, I will have a 1 for column B and blank values for C and D.
    I want to have a new column (column E) with a formula that displays the actual result (e.g. B) instead of the 1's

    How would I do that?

    Thanks so much!
    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. Replies: 4
    Last Post: 07-01-2020, 02:13 AM
  2. [SOLVED] Return Value Based on Column Row Pivot Table
    By raychow22 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-24-2020, 08:19 PM
  3. Replies: 8
    Last Post: 11-11-2016, 09:46 AM
  4. Format a pivot table based on values of a pivot column
    By chytechplus in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-25-2016, 06:32 AM
  5. Pivot Table - Search Row Label, Return column value
    By PORTER88 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-13-2015, 02:33 AM
  6. Replies: 11
    Last Post: 07-18-2013, 05:14 PM
  7. Replies: 1
    Last Post: 11-29-2005, 09:20 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