hustled my finds back from the shed to the cottage.

And I have been going through this stuff for hours ever since.I have three of the keepsake books given to families by funeral homes.

I had forgotten about the one for my great grandfather, Jo Desha Williams. And I didn't recall the telegrams.

Maxie followed the directions in the book to the letter.

First his obit...

Arkansas Gazette, Sunday, Dec. 24, 1950Jo Desha Williams, Salesman, DiesJo Desha Williams, aged 84, 2310 Ringo Street, died at his home Saturday. Mr. Williams was a traveling salesman for the U O Colson Co. of Paris, Ill. He was a member of the First Christian Church, a charter member of the Sons of the American Revolution, a member of the United Commercial Travelers, the WOW and the[Fail])
) piv

See SQL Fiddle with Demo
The UNPIVOT takes your column list and transform it into multiple rows which makes it much easier to count:
select Production_Site, value 
from t_Pqe_Grocery
unpivot
(
  value
  for col in (Grocery_Packaging_And_Coding, Grocery_Measurable,
              Grocery_Appearance, Grocery_Aroma, 
              Grocery_Flavour, Grocery_Texture)
) unp

Unpivot Result:
| PRODUCTION_SITE |  VALUE |
----------------------------
|          Site A | Target |
|          Site A | Action |
|          Site A |   Fail |
|          Site