Got Data? Post let's see what can be done.
Catherine, I didn't have a whole lot of time to play with this, and how to do this inside Tableau didn't pop out, I knew it would be easy to convert it Word. Here are the steps:
- Paste column into Word
- Convert table to text
- Replace all period with a blank
- Replace all commas with a blank (I forgot this step)
- Replace all paragraph marks (special drop down) with a space
- Replace all spaces with a paragraph mark
- Convert text to table
- Paste table into Excel
It sounds like a lot but it only took a couple of minutes. See attached workbook for results.
Word Cloud.twbx.zip 42.5 KB
Thank you so much, I'm very grateful. I got that to work. And I've read some of your other posts around this, so I see there are also tools you can use if I want to do it regularly, or I can set up a macro.
You're welcome, and a macro totally is the way to go.