counting common data and further split with pre-determined ratio by country with a specific ID code

I have a sample file attached where the column description as follows - column-A: a unique group of data, when counted it gives value of 78 column-B: Identifier for specific ID of group to map the ...