In the JAPANESE page, I put the sample file to make type 2 data using Excel VBA.
In Making Type 2 Data by Python , I use groupby function to calculate easily. But in Excel VBA, the program looks from head of the data to tail of the data. In the going, it caclculate type 2 data.