Thank you all so very much! I can stop beating my head on my desk now!

:-):-D:-P

Scott, thank you for your reply. When I run your solution like this:

SELECT

[values].value,

SUM(CASE WHEN Q1 = [values].value THEN 1 ELSE 0...

Sean,

Thank you for the welcome and for the link on how to create effective posts. Below you will find the script to recreate the table...