Spreadsheet: 90993d1290677729-excel-2007-counting-instances-of-words-countoccurrencesofwords
Sheet: Sheet1 (2)

The Source | Words per Row |  | Unique Words | Occurances
I have a long list of terms in the 'A' column | 11 | F | a | 3 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0
Each term contains several different words | 6 | G | 'A' | 4 | 1 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0
What I would like to do is create a table that has two columns | 14 | H | and | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0
One column contains each individual word that occurs within the 'A' column | 11 | I | any | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
and the Second column in the table | 7 | J | attached | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0
would show the number of times that word occurs in in the 'A' column | 13 | K | column | 6 | 1 | 0 | 0 | 2 | 1 | 1 | 1 | 0 | 0 | 0
This table should fill itself in with each word that has occurred in the 'A' column | 15 | L | columns | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Hopefully I'm explaining myself well enough | 6 | M | contains | 2 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
I've attached a screenshot of the thing that I'm looking for | 11 | N | create | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Thanks so much for any help | 6 | O | different | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | P | do | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Q | Each | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | R | enough | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
 |  | S | explaining | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
 |  | T | fill | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0
 |  | U | for | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1
 |  | V | has | 2 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0
 |  | W | have | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | X | help | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
 |  | Y | Hopefully | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
 |  | Z | I | 2 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | AA | I'm | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0
 |  | AB | in | 5 | 1 | 0 | 0 | 0 | 1 | 1 | 2 | 0 | 0 | 0
 |  | AC | individual | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 |  | AD | is | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | AE | itself | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0
 |  | AF | I've | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0
 |  | AG | like | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | AH | list | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | AI | long | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | AJ | looking | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0
 |  | AK | much | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
 |  | AL | myself | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
 |  | AM | number | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0
 |  | AN | occurred | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0
 |  | AO | occurs | 2 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0
 |  | AP | of | 3 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0
 |  | AQ | One | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 |  | AR | screenshot | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0
 |  | AS | Second | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0
 |  | AT | several | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | AU | should | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0
 |  | AV | show | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0
 |  | AW | so | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
 |  | AX | table | 3 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0
 |  | AY | term | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | AZ | terms | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | BA | Thanks | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
 |  | BB | that | 5 | 0 | 0 | 1 | 1 | 0 | 1 | 1 | 0 | 1 | 0
 |  | BC | the | 8 | 1 | 0 | 0 | 1 | 2 | 2 | 1 | 0 | 1 | 0
 |  | BD | thing | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0
 |  | BE | This | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0
 |  | BF | times | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0
 |  | BG | to | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | BH | two | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | BI | well | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
 |  | BJ | What | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | BK | with | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0
 |  | BL | within | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 |  | BM | word | 3 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0
 |  | BN | words | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | BO | would | 2 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0
 |  | BP
 |  | BQ
 |  | BR
 |  | BS
 |  | BT
 |  | BU
 |  | BV
 |  | BW
 |  | BX
 |  | BY
 |  | BZ