Hello Guru's, I am a new member and rusty Excel user.

I have just extracted some data from SAP and need to analyse the data, I have attched a sample extract of some of the data (in the attached) and would like to know the best way of achivieing the data analysis / extract. Please see the Table at the top of the attached sheet that I am trying to complete.

Would pivot table, advanced filter or countif work.

Many thanks in advance

Pivot table - Advanced filter or Countif.xlsx