Deliminating and Re-Combining cells

[jschena]

I'm not quite sure what I'm even asking, but I'll throw it out there anyway.

I have a spreadsheet that is exported from a piece of software. It has a column that describes the related work, labeled Tags. The tags column has each tag in it, separated by commas. I need to be able to see how many of each type of work there is for each store. (Using the stores is just an example, I am actually doing a ticketing system, much like a help-desk ticketing system). For example:

Store	Ticket Number	Tags
Petco	1234	cats, dogs, birds, fish
Petco	1245	birds, fish
Animal Lovers	1210	dogs
AnimalLovers	1211	dogs, frogs, whales, dolphins
Shelter	1252	cats, dolphins

<tbody>
</tbody>

So if Petco has 5 tickets that include "cats" in the tags, I need to be able to put this into a pivot table.

OUTCOME:

Store	cats	dogs	birds	fish	frogs	whales	dolphins
Petco	1	1	2	2	0	0	0
Animal Lovers	0	2	0	0	1	1	1
Shelter	1	0	0	0	0	0	1

<tbody>
</tbody>

***Is there a way to do this (steps?) without having to use VBA/macros?

 

[AvcGJS]

Countifs should do it combined with a wild card

eg

=COUNTIFS($A$3:$A$8,"Petco",$C$3:$C$8,"*cats*")
=COUNTIFS($A$3:$A$8,"Petco",$C$3:$C$8,"*dogs*")
=COUNTIFS($A$3:$A$8,"Petco",$C$3:$C$8,"*whales*") and so on.

 

[jschena]

Countifs should do it combined with a wild card

eg

=COUNTIFS($A$3:$A$8,"Petco",$C$3:$C$8,"*cats*")
=COUNTIFS($A$3:$A$8,"Petco",$C$3:$C$8,"*dogs*")
=COUNTIFS($A$3:$A$8,"Petco",$C$3:$C$8,"*whales*") and so on.

Hmm this would be a great solution, but there are about 30 different choices of Tags, making that include too much data manipulation