I have a csv file with a number of records with paragraphs of text stored as free text strings and I would like to search across all the entries in the column and produce a frequency table of the most used words within all the records
The effect I'm looking to obtain is similar to a word cloud with the most frequently used words given prominence.
I considered splitting the paragraphs up using the spaces as delimiters but that seems very messy. Anyone got a better way?
thanks!
Solved! Go to Solution.
Transpose to Rows and then use Text to Columns and Split to Rows on spaces. Then, summarise tool on the value by using Group By and Count.
Perfect, thank you!
Can you please elaborate with words or with a dummy file?