+ Reply to Thread
Results 1 to 3 of 3

Concatenate Pivot Table fields based on criteria

  1. #1
    Valued Forum Contributor
    Join Date
    04-13-2011
    Location
    Ottawa, Canada
    MS-Off Ver
    365
    Posts
    957

    Concatenate Pivot Table fields based on criteria

    Hello Excel VBA experts,

    I NEED your help!

    In summary, I need to concatenate fields that are from Pivot Table based on criteria.

    I have attached an excel file with different scenarios (each color represent a scenario) and a desired result that I want to accomplish (column E and F) of the file.

    The idea behind concatenate Field 3 is to look at Field 3 with respect to Field 1 and Field 2.

    The idea behind concatenate Field 1 and 2 is to look at field 2 with respect to Field 1. Thus, for each Field 2 values with respect to Field 1, it needs to concatenate.

    Cell A3 to C15 is the "LOOK" of the Pivot Table after it's been made from the Raw Data (A23:C34)

    Scenario 1 (red):
    Concatenate 1 value from Field 2 to 1 value from Field 1.
    Concatenate 3 values from Field 3.

    Scenario 2 (blue):
    Concatenate 2 values from Field 2 to 1 value from Field 1.
    Concatenate 2 values EACH from Field 3 to Field 1 and Field 2.

    Scenario 3 (green):
    Concatenate 3 values from Field 2 to 1 value from Field 1 .
    No Concatenate

    Scenario 4 (orange):
    Concatenate 1 value from Field 2 to 1 value from Field 1.
    No Concatenate

    My APOLOGIES of not being clear. I hope that the attached excel file could make you understand what I'm trying to accomplish.

    concatenate.xlsx

  2. #2
    Valued Forum Contributor
    Join Date
    04-13-2011
    Location
    Ottawa, Canada
    MS-Off Ver
    365
    Posts
    957

    Re: Concatenate Pivot Table fields based on criteria

    I don't know if I can BUMP, if not, my apologies admin since I can't find in the forum rules.

  3. #3
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux - O365
    Posts
    12,576

    Re: Concatenate Pivot Table fields based on criteria

    Hi
    I think there is a rule somewhere that asks to wait 24 hrs before bumping, but I've never seen anyone getting nervous about it, except for members bumping every hour or so ( which is rare)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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