Count only distinct observation based in ID - data in long format

In ex 2007 and younger are simple (formula - COUNTIFS) or create a table based on the data model. But for your release, you can do this by using columns of the auxiliary, which count uniques (unsorted source data).