Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Mar 2014
    Thanked 0 Times in 0 Posts

    Problem with Pivot Table.

    Any body please help me in attached file i have issue in pivot table i want to marge musa and musa(acting) in 1 singal bar or in 1 singal column please guied me whats the formula to marge both fields in 1 column untitled.JPG

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Pittsburgh, Pennsylvania, USA
    Thanked 342 Times in 335 Posts
    There is no attached file, just a picture.

    Since this seems to be a pivot chart, I would suggest you go to the source data and add a new column of "merged Names" (or whatever you want to call it). In this you can put the name you want to group in. You can do this manually (since there does not appear to be many names) by auto-filtering on the various Supv names and then filling the mergedName column with the name you want to use. If there are a lot of names, what you could do is create a list of all the names and what the merge name should be (on a separate sheet perhaps) and then use VLookup to get the merged name.

    Once you have the merged name column, you can use this in the pivot chart.

    Post back if you need more details or if I misunderstood your request


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts