Text to Column and Transpose help needed

[viv_ienne]

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

[jasperlch · Accepted solution]

Hi, I think the method mentioned could already produce what you need. I have also added a list of 'words to remove' and a Join tool to remove these words. Please let me know if it is what you need.

[viv_ienne]

Thanks Jasperlch! Exactly what I was after :)