there has gotta be a better way to do this!!!!

i want to create a pivot table to identify records (drilled down) from a
couple of drop down lists, the number of times a certain (or number of
certain) word(s) appear in a table of around 2250 rows

One column 'ironx' has words such as critical, extreme, satusfactory etc...

Is there a way to count these words down the page, and have other headings
(tinx, copperx etc.) across the page which have the same data..

maybe it's a mental block, (and yes i am a bit hungover)... i shouldn't
drink :) but i can't get past this...