3 Replies Latest reply on Apr 25, 2018 7:40 AM by Jyothisree Rayagiri

    Aggregate of Values From Multiple Columns

    Jim Wilcox

      Hi Guys,

       

      Here is what I am trying to do. I have multiple 'Reason' Columns with multiple values. For each reason column, there is a count column representing the quantity of the reasons. I would like to combine all the values from each reason column and aggregate the the counts for each reason. I've tried pivoting, but can't seem to get the numbers correct! See my example below:

       

      I have this:

       

      Reason 1Count 1Reason 2Count 2Reason 3
      Count 3
      Bathroom2Break5Break1
      Break1Lunch6Bathroom2
      Other4Other3Lunch6
      Lunch6Bathrroom1

       

      And need this:

       

      ReasonCount
      Bathroom5
      Break7
      Other7
      Lunch18

       

      Workbook attached!!

       

      Thanks in advance!!