Forum Discussion
How do I Count words in multiple columns
Hi, I want to know how to count how many times appear a word in each column: Example: there are 4 columns with replacements of a device, I want to count hoy many times appear each word on ...
Hello, I have a question about this too but didn't want to make a new post. My data:
| How did you find the overall learning experience - Please select all that apply - max 4 |
| thought provoking ;practical ;empowering;inspiring; |
| easy to apply ;practical ;empowering;relevant; |
| empowering;relevant;inspiring;thought provoking ; |
| thought provoking ;practical ;empowering;worthwhile; |
| thought provoking ;empowering;relevant;worthwhile; |
| thought provoking ; easy to apply ;practical ;relevant; |
| thought provoking ;practical ;relevant;worthwhile; |
| worthwhile;practical ;thought provoking ; easy to apply ; |
| thought provoking ;practical ;relevant;worthwhile; |
| thought provoking ;practical ;empowering;relevant; |
| thought provoking ;practical ;empowering;relevant; |
| inspiring;reactive to audience; |
| thought provoking ;empowering;worthwhile;relevant; |
I applied the Split Columns by delimiter but now I want to show the word count totals in a chart.
How do I count and merge 4 columns.
Hi,
In the Split by Delimiter window, expand Advanced Options and select Rows. Now all responses will appear in a single column. You should now be able to build your chart.
