Particular text count based on condition

Dear all, I am having new challenge, need to solve macro or formula solution. Here is my input data in the cell A & cell B.

BSE ID	LS          SPID     SLC      ST
BSE62	3-2137         MGW36    11   C7GST-166
BSE62	3-1160         TRE60     7   C7GST-15
BSE66	3-2136         MGW36     6   C7GST-13
BSE66	3-1161         TRE61     0   C7GSTAH-161
BSE66	3-1161         TRE61     0   C7GSTAH-161
BSE66	3-2136         MGW36     2   C7GST-5
BSE63	3-1161         TRE61    14   C7GST-141
BSE63	3-1161         TRE61    12   C7GST-137
BSE63	3-1161         TRE62     1   C7GSTAH-161

need output like below in the output sheet start from cell C,D,E

BSE ID	C7GST	C7GSTAH
BSE62	2	
BSE66	2	2
BSE63	2	1

please check the attachment

Hi martindwilson , Thanks for your repay, it works well. but i will be more happy if any macro solution is there , as my first part of the project already done by macro.

Hi martindwilson , here my data range is not fixed (i have given 10 data as an example ), sometime data range 65536 or some time 10,00000. so if data range is big
then it takes lots of time to complete the whole output.
please not that your solution is ok , & i am planing to use it , but for slowness , i am seeking for speeding way. i mean macro solution