I have a number of words in different rows and columns and I'm trying to use a pivot table to tell me how many times the individual words are repeated in each of the columns. I thought I had it counting that, but it was actually counting how many times the word came up in the first column and then how many times any of the words came up in the same row in later columns. Does that make sense?
Solved by F. F. in 27 mins