Forum Discussion

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor

    CatherineMadden First of all, the data set with over 400K rows contains 164K rows that have texts ("0" or "Helper Col. 2/rop #") or #N/A# errors in the Points column. So, it will be difficult to make any useful summary until that's fixed.

     

    Once you have corrected that, you can do a Pivot Table where you put the OP and Date in the Row area and the Points in Value area. Dates will probably be grouped by years, quarters and months automatically. Ungroup/expand these if you like.

Resources