2 Replies Latest reply on Mar 14, 2016 5:32 PM by Barb Reiser

    Help- Data Arrangement

    Barb Reiser

      Hello,

       

      I'm wanting to know if there is a way to format the attached data to have "Exceeds, Meets, Needs Help, Didn't Meet, NA" as separate columns and find out the percent of total for each category. The table below is how I would like the data to appear. I know I can do separate sheets for each category, but I would like to have it all on one sheet if possible.

       

      Can anyone help please?

       

      CategoryExceedsMeetsNeeds HelpDidn't MeetNA
      Apples%%%%%
      Bananas%%%%%
      Avocados%%%%%