+ Reply to Thread
Results 1 to 3 of 3

Any way to Merge Pivot Data

  1. 03-29-2014, 11:44 AM #1
    wpm7113
    wpm7113 is offline
    Registered User
    Join Date
    05-14-2008
    Location
    Hong Kong
    MS-Off Ver
    2019
    Posts
    57

    Any way to Merge Pivot Data

    Hi There, I need to ask for advice and hope you can help me out here.

    I got the following data and I like the results to be:

    Data

    Company | Country
    ABC | USA
    ABC | London
    BBB | USA
    CCC | USA

    Results:

    Company | Country
    ABC | USA, London
    BBB | USA
    CCC | USA

    Is it possible to this under Pivot? as I need to consolidate lots of data...

    Please help.

    Ray
    Reply With QuoteRegister To Reply
  2. 03-29-2014, 12:50 PM #2
    moinsk21
    moinsk21 is offline
    Registered User
    Join Date
    03-19-2014
    Location
    India
    MS-Off Ver
    Excel & VBA - 2007 & 2010
    Posts
    60

    Re: Any way to Merge Pivot Data

    Hi,

    It will be helpful to understand if you upload the spreadsheet with the example.
    Reply With QuoteRegister To Reply
  3. 03-29-2014, 09:45 PM #3
    wpm7113
    wpm7113 is offline
    Registered User
    Join Date
    05-14-2008
    Location
    Hong Kong
    MS-Off Ver
    2019
    Posts
    57

    Re: Any way to Merge Pivot Data

    Thanks Moinsk21 - Please find the example data for your reference.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Mail Merge: The merge provides data from the previous record
    By bellevue in forum Excel General
    Replies: 3
    Last Post: 10-23-2012, 07:44 AM
  2. Mail Merge or just Merge Spreadsheet Data
    By Mooch in forum Excel General
    Replies: 3
    Last Post: 12-07-2010, 04:56 PM
  3. mail merge excludes my headers and critical data in Word merge
    By Nix in forum Excel General
    Replies: 0
    Last Post: 04-21-2006, 03:40 PM
  4. how do i get my mail merge to update the data source at each merge
    By Steel_Monkey in forum Excel General
    Replies: 0
    Last Post: 11-30-2005, 04:45 AM
  5. [SOLVED] Merge Pivot Tables
    By [email protected] in forum Excel General
    Replies: 1
    Last Post: 06-13-2005, 09:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1