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:
<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:
<tbody>
</tbody>
***Is there a way to do this (steps?) without having to use VBA/macros?
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?