3 Replies Latest reply: Aug 25, 2016 8:18 PM by Lech Miszkiewicz RSS

    Calculating different metrics from a single column

    Brian Casstevens

      Hi,

       

      I have a large report in Excel that contains different types of medical procedures in one column, as below (not real claim data). How do I manipulate the data to put in a chart grouped by each type of procedure (ECG, Heart Cath, etc.)?

       

        

      Procedure Cost
      Open Heart Surgery $         15,000
      Open Heart Surgery $         15,000
      ECG $               300
      Heart Cath $            2,500
      ECG $               300
      ECG $               300
      ECG $               300