Consolidating biological data into occurance of each biological unit per sample in table

Select or download this

occurence1    A    a__bear;c__black
occurence2    B    a__wolf;c__grey
...
occurence28    C    a__bear;c__brown
occurence29    B    a__wolf;c__red
occurence30    B    a__wolf;c__grey

Select or download this

    A    B    C
wolf    4    7    5
bear    6    2    6

Select or download this

    A    B    C
black    1    0    1
...
white    1    0    1
brown    3    1    4
red    1    1    0

Select Code to Download