Thanks for getting back to me so promptly.
Yes, unfortunately values at the user-end are 'yes', 'no' and 'N/A' as this is a questionnaire type of data collection.
'Yes' and 'N/A' = 1 while 'No' = 0 so I would like to convert these within the QV application as well as group them there but I am prepared to convert the file before it's loaded if need be.
As for sums, I attach another file - this is what my customer used to see via their old process.
I have transposed these data items for better clarity ('by observation' column) as the layout may not be not immediately obvious having a different number of questions within each tool.
Again, many thanks.