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

The Source Strings | Words per Row | 100 words : 62 unique | Unique Words | Occurrences
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
 |  | CA
 |  | CB
 |  | CC
 |  | CD
 |  | CE
 |  | CF
 |  | CG
 |  | CH
 |  | CI
 |  | CJ
 |  | CK
 |  | CL
 |  | CM
 |  | CN
 |  | CO
 |  | CP
 |  | CQ
 |  | CR
 |  | CS
 |  | CT
 |  | CU
 |  | [NAME]
 |  | CW
 |  | CX
 |  | CY
 |  | CZ
 |  | DA
 |  | DB
 |  | DC
 |  | DD
 |  | DE
 |  | DF
 |  | DG
 |  | DH
 |  | DI
 |  | DJ
 |  | DK
 |  | DL
 |  | DM
 |  | DN
 |  | DO
 |  | DP
 |  | DQ
 |  | DR
 |  | DS
 |  | DT
 |  | DU
 |  | DV
 |  | DW
 |  | DX
 |  | DY
 |  | DZ
 |  | EA
 |  | EB
 |  | EC
 |  | ED
 |  | EE
 |  | EF
 |  | EG
 |  | EH
 |  | EI
 |  | EJ
 |  | EK
 |  | EL
 |  | EM
 |  | EN
 |  | EO
 |  | EP
 |  | EQ
 |  | ER
 |  | ES
 |  | ET
 |  | EU
 |  | EV
 |  | EW
 |  | EX
 |  | EY
 |  | EZ
 |  | FA
 |  | FB
 |  | FC
 |  | FD
 |  | FE
 |  | FF
 |  | FG
 |  | FH
 |  | FI
 |  | FJ
 |  | FK
 |  | FL
 |  | FM
 |  | FN
 |  | FO
 |  | FP
 |  | FQ
 |  | FR
 |  | FS
 |  | FT
 |  | FU
 |  | FV
 |  | FW
 |  | FX
 |  | FY
 |  | FZ
 |  | GA
 |  | GB
 |  | GC
 |  | [NAME]
 |  | GE
 |  | GF
 |  | GG
 |  | GH
 |  | GI
 |  | GJ
 |  | GK
 |  | GL
 |  | GM
 |  | GN
 |  | GO
 |  | GP
 |  | GQ
 |  | GR
 |  | GS
 |  | GT
 |  | GU
 |  | GV
 |  | GW
 |  | GX
 |  | GY
 |  | GZ
 |  | HA
 |  | HB
 |  | HC
 |  | HD
 |  | HE
 |  | HF
 |  | HG
 |  | HH
 |  | HI
 |  | HJ
 |  | HK
 |  | HL
 |  | HM
 |  | HN
 |  | HO
 |  | HP
 |  | HQ
 |  | HR
 |  | HS
 |  | HT
 |  | [NAME]
 |  | HV
 |  | HW
 |  | HX
 |  | HY
 |  | HZ
 |  | IA
 |  | IB
 |  | IC
 |  | ID
 |  | IE
 |  | IF
 |  | IG
 |  | IH
 |  | II
 |  | IJ
 |  | IK
 |  | IL
 |  | IM
 |  | IN
 |  | IO
 |  | IP
 |  | IQ
 |  | IR
 |  | IS
 |  | IT
 |  | IU
 |  | IV