Count unique text strings in a column

I'd appreciate some help.

I have a column of tags. Each cell can have multiple tags separated by commas. Each cell will have a unique set of tags within that cell, but tags can be repeated in other rows.

e.g.
Dog, Duck, Barn, Door
Dog, Cat, Cow
Door, Sheep, Goat
Barn, Farmer, Dog

How do I list out the unique tags only and then count how many of those unique tags are in the column?

Ideally what I'd like is the unique tags listed in one column with the count in the next column. e.g.

Dog 3
Duck 1
Barn 2
Door 2
Cat 1
Cow 1
Sheep 1
Goat 1
Farmer 1

thanks

Please try:

Formula:

Please Login or Register  to view this content.