I have a list of patients who have pulmonary nodule treatment with three different types of embolic agents (MVP, AVM, or Coil). My data is saved as presented below. I want to know the following count

How many patients (ID) have only MVP?
How many patients (ID) have only Coil?
How many patients (ID) have MVP and Coil?
How many patients (ID) have AVP and Coil?

Also, I want to count how many coils per patients (ID)






ID Embolic1 Embolic2 Embolic3 Embolic4 Embolic5 Embolic6 Embolic7 Embolic8 Embolic9 Embolic10 Embolic11

1 MVP

2 Coil Coil Coil Coil Coil Coil Coil Coil Coil Coil Coil

3 Coil Coil

3 AVP AVP

3 Coil Coil

3 Coil Coil Coil Coil Coil Coil Coil

3 Coil Coil

3 Coil Coil

3 Coil Coil Coil Coil Coil Coil

3 Coil Coil Coil Coil Coil Coil Coil Coil

3 Coil Coil Coil Coil Coil Coil Coil

3 Coil Coil

3 MVP Coil Coil Coil Coil Coil Coil Coil Coil Coil

3 Coil Coil

3 Coil Coil Coil Coil Coil Coil Coil Coil Coil Coil Coil

4 Coil Coil

4 Coil Coil

5 Coil Coil

5 Coil Coil

5 Coil

6 Coil Coil Coil Coil Coil

7 MVP

7 MVP Coil

8 MVP Coil Coil Coil Coil

9 Coil Coil Coil Coil

10 AVP

11 AVP

11 Coil Coil Coil Coil Coil Coil

11 AVP

11 Coil Coil Coil Coil Coil Coil

12 Coil Coil Coil

12 AVP

13 Coil Coil Coil Coil

14 Coil Coil Coil

15 Coil Coil Coil Coil Coil

15 Coil Coil Coil Coil Coil Coil Coil Coil Coil Coil Coil

15 AVP

15 Coil

15 Coil Coil Coil Coil Coil Coil Coil Coil Coil Coil

15 Coil Coil Coil Coil Coil Coil Coil Coil

15 AVP