Hi All,
I have some data which looks like the following:
CaseID | Category | Sub-Category | Verbatim |
1 | dairy | milk | milk is delicious and healthy |
2 | protein | beef | unhappy with service |
3 | carb | rice | dissatisfied with quality of rice |
What I've done is created word tags out of the verbatim (Text to Columns -> Split to Rows on Verbatim column and remove common words). However, i am struggling to create the following type of output:
CaseID | Category | Sub-Category | Tags |
1 | dairy | milk | milk |
1 | dairy | milk | delicious |
1 | dairy | milk | healthy |
2 | protein | beef | unhappy |
2 | protein | beef | service |
3 | carb | rice | dissatisfied |
3 | carb | rice | quality |
3 | carb | rice | rice |
As you can see, for each word tags of each verbatim, I would like to create a row for that, so that I can associate each tag with the category in which it came from.
Would really appreciate any insights and tips on this!!
Many thanks!
-Viv
Solved! Go to Solution.
Thanks Jasperlch! Exactly what I was after :)